APPS.IGS_CO_GEN_002 dependencies on IGS_CO_S_PERLT_RPTGP

Line 89: cp_sequence_number IGS_CO_S_PERLT_RPTGP.sequence_number%TYPE,

85: WHERE splp.spl_sequence_number = cp_sequence_number
86: AND splp.person_id = cp_person_id
87: FOR UPDATE OF splp.spl_sequence_number NOWAIT;
88: CURSOR c_splrg(
89: cp_sequence_number IGS_CO_S_PERLT_RPTGP.sequence_number%TYPE,
90: cp_person_id IGS_CO_S_PERLT_RPTGP.person_id%TYPE) IS
91: SELECT ROWID
92: FROM IGS_CO_S_PERLT_RPTGP splrg
93: WHERE splrg.spl_sequence_number = cp_sequence_number

Line 90: cp_person_id IGS_CO_S_PERLT_RPTGP.person_id%TYPE) IS

86: AND splp.person_id = cp_person_id
87: FOR UPDATE OF splp.spl_sequence_number NOWAIT;
88: CURSOR c_splrg(
89: cp_sequence_number IGS_CO_S_PERLT_RPTGP.sequence_number%TYPE,
90: cp_person_id IGS_CO_S_PERLT_RPTGP.person_id%TYPE) IS
91: SELECT ROWID
92: FROM IGS_CO_S_PERLT_RPTGP splrg
93: WHERE splrg.spl_sequence_number = cp_sequence_number
94: AND splrg.person_id = cp_person_id

Line 92: FROM IGS_CO_S_PERLT_RPTGP splrg

88: CURSOR c_splrg(
89: cp_sequence_number IGS_CO_S_PERLT_RPTGP.sequence_number%TYPE,
90: cp_person_id IGS_CO_S_PERLT_RPTGP.person_id%TYPE) IS
91: SELECT ROWID
92: FROM IGS_CO_S_PERLT_RPTGP splrg
93: WHERE splrg.spl_sequence_number = cp_sequence_number
94: AND splrg.person_id = cp_person_id
95: ORDER BY splrg.sequence_number DESC, splrg.sup_repeating_group_cd
96: FOR UPDATE OF splrg.spl_sequence_number NOWAIT;

Line 203: IGS_CO_S_PERLT_RPTGP_PKG.DELETE_ROW(X_ROWID=>v_splrg_rec.ROWID);

199: -- table can contain parent/child relationship
200: FOR v_splrg_rec IN c_splrg(
201: v_spl_sequence_number,
202: v_ocr_rec.person_id) LOOP
203: IGS_CO_S_PERLT_RPTGP_PKG.DELETE_ROW(X_ROWID=>v_splrg_rec.ROWID);
204: END LOOP;
205: -- remove the reference to the IGS_CO_S_PER_LTR sequence number
206: -- from the IGS_AD_APPL_LTR record
207: FOR v_aal_rec IN c_aal(