| data insert problem [message #275009] |
Thu, 18 October 2007 02:01  |
muralibanala
Messages: 2
Registered: October 2007
Location: bangalore
|
Junior Member |
|
|
exposure_pkg.create_injury_file_review (:NEW.roi_id, :NEW.claimant_id, :NEW.exposure_id, :NEW.exposure_number,TRUNC(:NEW.auddate_cre) ); iam calling this in trigger
PROCEDURE create_injury_file_review (p_roi_id IN exposure.roi_id%TYPE,
p_claimant_id IN exposure.claimant_id%TYPE,
p_exposure_id IN exposure.exposure_id%TYPE,
p_exposure_num IN exposure.exposure_number%TYPE,
p_auddate_cre IN exposure.auddate_cre%TYPE) IS
nFirstInjFileReview NUMBER;
nRoiNumber roi.roi_number%TYPE;
rCprRec Cpr_Pkg.cpr_rec;
nrptddate roi_rptd.rptd_date%TYPE;
nExpNumber exposure.exposure_number%TYPE;
BEGIN
IF p_exposure_id IS NOT NULL THEN
nrptddate :=Apputil.getrptddate(p_roi_id);
nRoiNumber := Apputil.getRoiNumber(p_roi_id);
nExpNumber := p_exposure_num;
nFirstInjFileReview := Parameter_Pkg.get_internal_level_code_value('1ST INJURY FILE REVIEW');
rCprRec.nROI_Id := p_roi_id;
rCprRec.nExposure_Id := p_exposure_id;
rCprRec.nClaimant_Id := p_claimant_id;
--RAISE_APPLICATION_ERROR(-20100,' RoiId'||nrptddate);
dbms_output.put_line ('Date: '||to_char(nrptddate,'dd/mm/yyyy'));
--1st Injury File Review
rCprRec.vProcess := 'BATCH_1ST_INJURY_FILE_REVIEW';
rCprRec.vText := (nFirstInjFileReview/7)
||' WEEK REVIEW DUE FOR :'
||' ROI#'||nRoiNumber||' - '||'EXP#'||nExpNumber;
rCprRec.dRunDate := nrptddate +(nvl(nFirstInjFileReview,0)-7); here inserted into null
rCprRec.dRequestDate := rCprRec.dRunDate+7;here inserted into null
Cpr_Pkg.creat(rCprRec); this will insert data except date all other are inserting
end;
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
