APPS.IGS_PS_SCH_INT_API_PUB dependencies on IGS_PS_SCH_USEC_INT

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 ,

Line 521: IGS_PS_SCH_USEC_INT_S.NEXTVAL,

517: last_update_date ,
518: last_update_login
519: )
520: VALUES (
521: IGS_PS_SCH_USEC_INT_S.NEXTVAL,
522: p_cal_type,
523: p_sequence_number,
524: NULL,
525: NULL,

Line 813: IGS_PS_SCH_USEC_INT ps

809: psi.*,
810: ps.unit_section_start_date us_start_date,
811: ps.unit_section_end_date us_end_date
812: FROM IGS_PS_SCH_INT_ALL psi,
813: IGS_PS_SCH_USEC_INT ps
814: WHERE psi.int_occurs_id = cp_int_occurs_id AND
815: psi.int_usec_id = ps.int_usec_id;
816:
817: -- Cursor added as part of Enh bug#2833850