APPS.IGS_PR_GEN_003 dependencies on IGS_PR_S_SCRATCH_PAD

Line 1276: --SELECT IGS_PR_S_SCRATCH_PAD_S.nextval

1272: BEGIN
1273: DECLARE
1274: v_other_detail VARCHAR2(350);
1275: CURSOR c_get_nxt_seq IS
1276: --SELECT IGS_PR_S_SCRATCH_PAD_S.nextval
1277: SELECT IGS_PR_RU_APPL_SEQ_NUM_S.nextval
1278: FROM DUAL;
1279: v_ssp_sequence_number IGS_PR_S_SCRATCH_PAD.sequence_number%TYPE;
1280: BEGIN

Line 1279: v_ssp_sequence_number IGS_PR_S_SCRATCH_PAD.sequence_number%TYPE;

1275: CURSOR c_get_nxt_seq IS
1276: --SELECT IGS_PR_S_SCRATCH_PAD_S.nextval
1277: SELECT IGS_PR_RU_APPL_SEQ_NUM_S.nextval
1278: FROM DUAL;
1279: v_ssp_sequence_number IGS_PR_S_SCRATCH_PAD.sequence_number%TYPE;
1280: BEGIN
1281: -- this module inserts and entry into the
1282: -- system scratch pad table
1283: -- Get the next sequence number;

Line 1304: IGS_PR_S_SCRATCH_PAD_PKG.INSERT_ROW (

1300: lv_rowid VARCHAR2(25);
1301: l_org_id NUMBER(15);
1302: BEGIN
1303: l_org_id := igs_ge_gen_003.get_org_id;
1304: IGS_PR_S_SCRATCH_PAD_PKG.INSERT_ROW (
1305: X_ROWID =>lv_rowid,
1306: x_SEQUENCE_NUMBER =>v_ssp_sequence_number,
1307: x_CREATION_DT =>p_creation_dt,
1308: x_KEY =>p_key,