APPS.IGI_CIS_IGIPMTHP_PKG dependencies on IGI_CIS_MTH_RET_LINES_T

Line 86: tableclause := tableclause||' IGI_CIS_MTH_RET_HDR_T hdr, IGI_CIS_MTH_RET_LINES_T lines, IGI_CIS_MTH_RET_PAY_T pay ';

82: --Bug 5933093 end
83:
84: IF p_mode = 'P' THEN
85: pwhereclause := pwhereclause || ' AND request_status_code = ''P''';
86: tableclause := tableclause||' IGI_CIS_MTH_RET_HDR_T hdr, IGI_CIS_MTH_RET_LINES_T lines, IGI_CIS_MTH_RET_PAY_T pay ';
87: ELSE
88: pwhereclause := pwhereclause || ' AND request_status_code = ''C''';
89: tableclause := tableclause||' IGI_CIS_MTH_RET_HDR_H hdr, IGI_CIS_MTH_RET_LINES_H lines, IGI_CIS_MTH_RET_PAY_H pay ';
90: END IF ;

Line 156: delete from igi_cis_mth_ret_lines_t where header_id = l_header_id;

152: and request_status_code = 'P';
153: log(C_STATE_LEVEL, l_procedure_name, 'l_header_id='||l_header_id);
154: delete from igi_cis_mth_ret_hdr_t where header_id = l_header_id;
155: log(C_STATE_LEVEL, l_procedure_name, 'Deleted '||SQL%ROWCOUNT||' rows from igi_cis_mth_ret_hdr_t');
156: delete from igi_cis_mth_ret_lines_t where header_id = l_header_id;
157: log(C_STATE_LEVEL, l_procedure_name, 'Deleted '||SQL%ROWCOUNT||' rows from igi_cis_mth_ret_lines_t');
158: delete from igi_cis_mth_ret_pay_t where header_id = l_header_id;
159: log(C_STATE_LEVEL, l_procedure_name, 'Deleted '||SQL%ROWCOUNT||' rows from igi_cis_mth_ret_pay_t');
160: commit;

Line 157: log(C_STATE_LEVEL, l_procedure_name, 'Deleted '||SQL%ROWCOUNT||' rows from igi_cis_mth_ret_lines_t');

153: log(C_STATE_LEVEL, l_procedure_name, 'l_header_id='||l_header_id);
154: delete from igi_cis_mth_ret_hdr_t where header_id = l_header_id;
155: log(C_STATE_LEVEL, l_procedure_name, 'Deleted '||SQL%ROWCOUNT||' rows from igi_cis_mth_ret_hdr_t');
156: delete from igi_cis_mth_ret_lines_t where header_id = l_header_id;
157: log(C_STATE_LEVEL, l_procedure_name, 'Deleted '||SQL%ROWCOUNT||' rows from igi_cis_mth_ret_lines_t');
158: delete from igi_cis_mth_ret_pay_t where header_id = l_header_id;
159: log(C_STATE_LEVEL, l_procedure_name, 'Deleted '||SQL%ROWCOUNT||' rows from igi_cis_mth_ret_pay_t');
160: commit;
161: END IF;