APPS.IGS_CO_GEN_002 dependencies on IGS_AD_APPL_LTR

Line 98: cp_sequence_number IGS_AD_APPL_LTR.spl_sequence_number%TYPE,

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;
97: CURSOR c_aal(
98: cp_sequence_number IGS_AD_APPL_LTR.spl_sequence_number%TYPE,
99: cp_person_id IGS_AD_APPL_LTR.person_id%TYPE) IS
100: SELECT ROWID,
101: PERSON_ID,
102: ADMISSION_APPL_NUMBER,

Line 99: cp_person_id IGS_AD_APPL_LTR.person_id%TYPE) IS

95: ORDER BY splrg.sequence_number DESC, splrg.sup_repeating_group_cd
96: FOR UPDATE OF splrg.spl_sequence_number NOWAIT;
97: CURSOR c_aal(
98: cp_sequence_number IGS_AD_APPL_LTR.spl_sequence_number%TYPE,
99: cp_person_id IGS_AD_APPL_LTR.person_id%TYPE) IS
100: SELECT ROWID,
101: PERSON_ID,
102: ADMISSION_APPL_NUMBER,
103: CORRESPONDENCE_TYPE,

Line 108: FROM IGS_AD_APPL_LTR aal

104: SEQUENCE_NUMBER,
105: COMPOSED_IND,
106: LETTER_REFERENCE_NUMBER,
107: SPL_SEQUENCE_NUMBER
108: FROM IGS_AD_APPL_LTR aal
109: WHERE aal.spl_sequence_number = cp_sequence_number
110: AND aal.person_id = cp_person_id
111: FOR UPDATE OF aal.letter_reference_number, aal.spl_sequence_number NOWAIT;
112: CURSOR c_ocr_1(

Line 206: -- from the IGS_AD_APPL_LTR record

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
210: IGS_AD_APPL_LTR_PKG.UPDATE_ROW(

Line 210: IGS_AD_APPL_LTR_PKG.UPDATE_ROW(

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
210: IGS_AD_APPL_LTR_PKG.UPDATE_ROW(
211: X_ROWID => v_aal_rec.ROWID,
212: X_PERSON_ID => v_aal_rec.PERSON_ID,
213: X_ADMISSION_APPL_NUMBER =>v_aal_rec.ADMISSION_APPL_NUMBER ,
214: X_CORRESPONDENCE_TYPE =>v_aal_rec.CORRESPONDENCE_TYPE,