eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_CO_GEN_002 dependencies on IGS_CO_S_PER_LT_PARM_PKG

Line 196: IGS_CO_S_PER_LT_PARM_PKG.DELETE_ROW(X_ROWID=>v_splp_rec.ROWID);

192: -- delete any parameters for this letter
193: FOR v_splp_rec IN c_splp(
194: v_spl_sequence_number,
195: v_ocr_rec.person_id) LOOP
196: IGS_CO_S_PER_LT_PARM_PKG.DELETE_ROW(X_ROWID=>v_splp_rec.ROWID);
197: END LOOP;
198: -- delete the repeating groups. Must delete in the correct order as
199: -- table can contain parent/child relationship
200: FOR v_splrg_rec IN c_splrg(

Line 459: IGS_CO_S_PER_LT_PARM_PKG.INSERT_ROW(X_ROWID=>X_ROWID,

455: -- splp_sequence_number.NEXTVAL
456: OPEN c_get_nxt_seq;
457: FETCH c_get_nxt_seq INTO v_sequence_number;
458: CLOSE c_get_nxt_seq;
459: IGS_CO_S_PER_LT_PARM_PKG.INSERT_ROW(X_ROWID=>X_ROWID,
460: X_PERSON_ID=>p_person_id,
461: X_CORRESPONDENCE_TYPE=>p_correspondence_type,
462: X_LETTER_REFERENCE_NUMBER=>p_letter_reference_number,
463: X_SPL_SEQUENCE_NUMBER=>p_spl_sequence_number,