APPS.IGS_PS_SCH_INT_API_PUB dependencies on IGS_PS_SCH_HDR_INT

Line 391: l_trans_id igs_ps_sch_hdr_int.transaction_id%TYPE;

387:
388: -- Records have to be inserted into the Schedule Interface Tables.
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.

Line 397: INSERT INTO igs_ps_sch_hdr_int (

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 (
398: transaction_id ,
399: originator ,
400: request_date ,
401: org_id

Line 404: IGS_PS_SCH_HDR_INT_S.NEXTVAL,

400: request_date ,
401: org_id
402: )
403: VALUES (
404: IGS_PS_SCH_HDR_INT_S.NEXTVAL,
405: 'EXTERNAL',
406: SYSDATE,
407: p_org_id ) RETURNING transaction_id INTO l_trans_id;
408: END;