APPS.IGS_AD_IMP_OFF_RESP_DATA dependencies on IGS_AD_PS_APPL_INST_PKG

Line 1167: igs_ad_ps_appl_inst_pkg.update_row (

1163:
1164: IF lv_un_conf_prg_atmpt --- if unconfirming SPA is successful
1165: THEN
1166:
1167: igs_ad_ps_appl_inst_pkg.update_row (
1168: x_mode => 'R',
1169: x_rowid => l_acaiv_rec.rowid,
1170: x_person_id => l_acaiv_rec.person_id,
1171: x_admission_appl_number => l_acaiv_rec.admission_appl_number,

Line 1308: logdetail(t_offresp_int_id(t_idx), 'E621', NULL,'imp_off_resp: igs_ad_ps_appl_inst_pkg.update_row',NULL);

1304: l_completed_flag := 'N';
1305: UPDATE igs_ad_offresp_int SET status = '3' WHERE offresp_int_id = t_offresp_int_id(t_idx);
1306: insert_int_error(t_offresp_int_id (t_idx),'E621',NULL);
1307:
1308: logdetail(t_offresp_int_id(t_idx), 'E621', NULL,'imp_off_resp: igs_ad_ps_appl_inst_pkg.update_row',NULL);
1309:
1310: --Loop through all messages in stack to check if there is Security Policy exception already set or not. Ref: Bug 3919112
1311: l_sc_msg_count := IGS_GE_MSG_STACK.COUNT_MSG;
1312: WHILE l_sc_msg_count <> 0 loop

Line 1324: END; --of igs_ad_ps_appl_inst_pkg.update_row

1320: END IF;
1321: l_sc_msg_count := l_sc_msg_count - 1;
1322: END LOOP;
1323:
1324: END; --of igs_ad_ps_appl_inst_pkg.update_row
1325: END IF;
1326:
1327: -- Else Insert proper Error message into the Error Interface table.
1328: -- Update the Current Interface Offer Response record with Status '3'.