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()
179: where HEADER_ID = p_in_header_id;
180: BEGIN
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()
179: where HEADER_ID = p_in_header_id;
180: BEGIN
181: select count(header_id)
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()
179: where HEADER_ID = p_in_header_id;
180: BEGIN
181: select count(header_id)
182: into l_cnt_header_id