Home » Developer & Programmer » Forms » data insert problem (i am inserting data into the table through trigger)
data insert problem [message #275009] Thu, 18 October 2007 02:01 Go to next message
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;
Re: data insert problem [message #275015 is a reply to message #275009] Thu, 18 October 2007 02:14 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
report

Reported By: muralibanala
On: Thu, 18 October 2007 09:02
In: Developer & Programmer Forms data insert problem
Reason i am facing the problem while inserting the data into one table

Don't report messages to get attention. Wait in line like everyone else.

MHE
Re: data insert problem [message #275022 is a reply to message #275015] Thu, 18 October 2007 02:23 Go to previous messageGo to next message
muralibanala
Messages: 2
Registered: October 2007
Location: bangalore
Junior Member
ok
Re: data insert problem [message #275085 is a reply to message #275022] Thu, 18 October 2007 04:19 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Will you, please, read the OraFAQ Forum Guide to learn how to properly ask a question here? Your post is unreadable. I understood you have a problem, and that's all I know.
Re: data insert problem [message #275235 is a reply to message #275009] Thu, 18 October 2007 22:51 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Is this a new form or a modification to an existing form?

David
Previous Topic: cannot save on master detail block
Next Topic: hierarchy tree
Goto Forum:
  


Current Time: Sat Dec 10 08:50:54 CST 2016

Total time taken to generate the page: 0.09990 seconds