APPS.IGI_CIS2007_IGIPMTHP_PKG dependencies on IGI_CIS_MTH_RET_HDR_T

Line 8: select IGI_CIS_MTH_RET_HDR_T_S.nextval into l_new_header_id from dual;

4: procedure populate_history (p_old_header_id number, p_request_status_code varchar2)
5: is
6: l_new_header_id number;
7: begin
8: select IGI_CIS_MTH_RET_HDR_T_S.nextval into l_new_header_id from dual;
9: insert into igi_cis_mth_ret_hdr_h
10: (HEADER_ID,
11: ORG_ID,
12: CIS_SENDER_ID,

Line 163: from igi_cis_mth_ret_hdr_t where header_id = p_in_header_id;

159:
160: --Following block added for bug # 6074547
161: begin
162: select count(header_id) into l_temp_count
163: from igi_cis_mth_ret_hdr_t where header_id = p_in_header_id;
164:
165: select count(header_id) into l_hist_count
166: from igi_cis_mth_ret_hdr_h where header_id = p_in_header_id;
167:

Line 174: update igi_cis_mth_ret_hdr_t

170: return;
171: end if;
172: end;
173:
174: update igi_cis_mth_ret_hdr_t
175: set REQUEST_STATUS_CODE = p_in_completion_code,
176: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID(),
177: PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID(),
178: PROGRAM_LOGIN_ID = FND_GLOBAL.CONC_LOGIN_ID()

Line 240: from igi_cis_mth_ret_hdr_t

236: LAST_UPDATED_BY,
237: LAST_UPDATE_LOGIN,
238: CREATION_DATE,
239: CREATED_BY
240: from igi_cis_mth_ret_hdr_t
241: where HEADER_ID = p_in_header_id ;
242: insert into igi_cis_mth_ret_lines_h
243: (HEADER_ID,
244: ORG_ID,

Line 330: delete from igi_cis_mth_ret_hdr_t where header_id = p_in_header_id;

326: TOTAL_DEDUCTIONS,
327: DISCOUNT_AMOUNT
328: from igi_cis_mth_ret_pay_t
329: where HEADER_ID = p_in_header_id ;
330: delete from igi_cis_mth_ret_hdr_t where header_id = p_in_header_id;
331: delete from igi_cis_mth_ret_lines_t where header_id = p_in_header_id;
332: delete from igi_cis_mth_ret_pay_t where header_id = p_in_header_id;
333: commit;
334: ELSE