DBA Data[Home] [Help]

APPS.IGS_PS_SCH_INT_API_PUB dependencies on IGS_PS_SCH_USEC_INT_ALL

Line 393: l_int_usec_id igs_ps_sch_usec_int_all.int_usec_id%TYPE ;

389:
390: DECLARE
391: l_trans_id igs_ps_sch_hdr_int.transaction_id%TYPE;
392: l_int_pat_id NUMBER;
393: l_int_usec_id igs_ps_sch_usec_int_all.int_usec_id%TYPE ;
394: BEGIN
395: -- create a header record for the process.
396: BEGIN
397: INSERT INTO igs_ps_sch_hdr_int (

Line 483: -- Insert Unit Section Interface Records (IGS_PS_SCH_USEC_INT_ALL)

479: END ;
480:
481:
482:
483: -- Insert Unit Section Interface Records (IGS_PS_SCH_USEC_INT_ALL)
484: BEGIN
485: INSERT INTO igs_ps_sch_usec_int_all (
486: int_usec_id ,
487: calendar_type ,

Line 485: INSERT INTO igs_ps_sch_usec_int_all (

481:
482:
483: -- Insert Unit Section Interface Records (IGS_PS_SCH_USEC_INT_ALL)
484: BEGIN
485: INSERT INTO igs_ps_sch_usec_int_all (
486: int_usec_id ,
487: calendar_type ,
488: sequence_number ,
489: unit_cd ,