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 167: from igi_cis_mth_ret_hdr_t where header_id = p_in_header_id;

163:
164: --Following block added for bug # 6074547
165: begin
166: select count(header_id) into l_temp_count
167: from igi_cis_mth_ret_hdr_t where header_id = p_in_header_id;
168:
169: select count(header_id) into l_hist_count
170: from igi_cis_mth_ret_hdr_h where header_id = p_in_header_id;
171:

Line 178: update igi_cis_mth_ret_hdr_t

174: return;
175: end if;
176: end;
177:
178: update igi_cis_mth_ret_hdr_t
179: set REQUEST_STATUS_CODE = p_in_completion_code,
180: PROGRAM_APPLICATION_ID = FND_GLOBAL.PROG_APPL_ID(),
181: PROGRAM_ID = FND_GLOBAL.CONC_PROGRAM_ID(),
182: PROGRAM_LOGIN_ID = FND_GLOBAL.CONC_LOGIN_ID()

Line 244: from igi_cis_mth_ret_hdr_t

240: LAST_UPDATED_BY,
241: LAST_UPDATE_LOGIN,
242: CREATION_DATE,
243: CREATED_BY
244: from igi_cis_mth_ret_hdr_t
245: where HEADER_ID = p_in_header_id ;
246: insert into igi_cis_mth_ret_lines_h
247: (HEADER_ID,
248: ORG_ID,

Line 338: delete from igi_cis_mth_ret_hdr_t where header_id = p_in_header_id;

334: CIS_TAX,
335: DISCOUNT_AMOUNT
336: from igi_cis_mth_ret_pay_t
337: where HEADER_ID = p_in_header_id ;
338: delete from igi_cis_mth_ret_hdr_t where header_id = p_in_header_id;
339: delete from igi_cis_mth_ret_lines_t where header_id = p_in_header_id;
340: delete from igi_cis_mth_ret_pay_t where header_id = p_in_header_id;
341: commit;
342: ELSE