APPS.IGS_CO_GEN_002 dependencies on IGS_CO_S_PER_LTR

Line 73: cp_sequence_number IGS_CO_S_PER_LTR.sequence_number%TYPE,

69: AND ocr.reference_number = cp_reference_number
70: AND ocr.S_OTHER_REFERENCE_TYPE = cst_spl_seqnum
71: FOR UPDATE OF ocr.other_reference NOWAIT;
72: CURSOR c_spl(
73: cp_sequence_number IGS_CO_S_PER_LTR.sequence_number%TYPE,
74: cp_person_id IGS_CO_S_PER_LTR.person_id%TYPE) IS
75: SELECT ROWID
76: FROM IGS_CO_S_PER_LTR spl
77: WHERE spl.sequence_number = cp_sequence_number

Line 74: cp_person_id IGS_CO_S_PER_LTR.person_id%TYPE) IS

70: AND ocr.S_OTHER_REFERENCE_TYPE = cst_spl_seqnum
71: FOR UPDATE OF ocr.other_reference NOWAIT;
72: CURSOR c_spl(
73: cp_sequence_number IGS_CO_S_PER_LTR.sequence_number%TYPE,
74: cp_person_id IGS_CO_S_PER_LTR.person_id%TYPE) IS
75: SELECT ROWID
76: FROM IGS_CO_S_PER_LTR spl
77: WHERE spl.sequence_number = cp_sequence_number
78: AND spl.person_id = cp_person_id

Line 76: FROM IGS_CO_S_PER_LTR spl

72: CURSOR c_spl(
73: cp_sequence_number IGS_CO_S_PER_LTR.sequence_number%TYPE,
74: cp_person_id IGS_CO_S_PER_LTR.person_id%TYPE) IS
75: SELECT ROWID
76: FROM IGS_CO_S_PER_LTR spl
77: WHERE spl.sequence_number = cp_sequence_number
78: AND spl.person_id = cp_person_id
79: FOR UPDATE OF spl.sequence_number NOWAIT;
80: CURSOR c_splp(

Line 184: -- find related IGS_CO_S_PER_LTR records from IGS_CO_OU_CO_REF

180: p_reference_number) LOOP
181: IGS_CO_DTL_PKG.DELETE_ROW(X_ROWID=>vcd_rec.ROWID);
182: END LOOP;
183: IF(p_letter_delete = 'Y') THEN
184: -- find related IGS_CO_S_PER_LTR records from IGS_CO_OU_CO_REF
185: FOR v_ocr_rec IN c_ocr(
186: p_correspondence_type,
187: p_reference_number) LOOP
188: v_spl_sequence_number := TO_NUMBER(v_ocr_rec.other_reference);

Line 205: -- remove the reference to the IGS_CO_S_PER_LTR sequence number

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(
208: v_spl_sequence_number,
209: v_ocr_rec.person_id) LOOP

Line 222: -- delete the IGS_CO_S_PER_LTR record

218: X_SPL_SEQUENCE_NUMBER =>NULL,
219: X_MODE => 'R'
220: );
221: END LOOP;
222: -- delete the IGS_CO_S_PER_LTR record
223: IGS_CO_S_PER_LTR_PKG.DELETE_ROW(X_ROWID => v_spl_rec.rowid);
224: END LOOP;
225: -- delete current IGS_CO_OU_CO_REF record
226: IGS_CO_OU_CO_REF_PKG.DELETE_ROW(X_ROWID => v_ocr_rec.ROWID );

Line 223: IGS_CO_S_PER_LTR_PKG.DELETE_ROW(X_ROWID => v_spl_rec.rowid);

219: X_MODE => 'R'
220: );
221: END LOOP;
222: -- delete the IGS_CO_S_PER_LTR record
223: IGS_CO_S_PER_LTR_PKG.DELETE_ROW(X_ROWID => v_spl_rec.rowid);
224: END LOOP;
225: -- delete current IGS_CO_OU_CO_REF record
226: IGS_CO_OU_CO_REF_PKG.DELETE_ROW(X_ROWID => v_ocr_rec.ROWID );
227: END LOOP;