eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_CIS2007_IGIPMTHP_PKG dependencies on IGI_CIS_MTH_RET_HDR_H

Line 9: insert into igi_cis_mth_ret_hdr_h

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,
13: TAX_OFFICE_NUMBER,

Line 58: from igi_cis_mth_ret_hdr_h

54: LAST_UPDATED_BY,
55: LAST_UPDATE_LOGIN,
56: CREATION_DATE,
57: CREATED_BY
58: from igi_cis_mth_ret_hdr_h
59: where HEADER_ID = p_old_header_id ;
60:
61: insert into igi_cis_mth_ret_lines_h
62: (HEADER_ID,

Line 170: from igi_cis_mth_ret_hdr_h where header_id = p_in_header_id;

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:
172: if l_temp_count = 0 and l_hist_count > 0 then
173: populate_history(p_in_header_id,p_in_completion_code);
174: return;

Line 187: from igi_cis_mth_ret_hdr_h

183: where HEADER_ID = p_in_header_id;
184: BEGIN
185: select count(header_id)
186: into l_cnt_header_id
187: from igi_cis_mth_ret_hdr_h
188: where header_id = p_in_header_id
189: group by header_id;
190: EXCEPTION
191: when no_data_found then

Line 195: insert into igi_cis_mth_ret_hdr_h

191: when no_data_found then
192: l_cnt_header_id := 0;
193: END;
194: IF (l_cnt_header_id = 0) THEN
195: insert into igi_cis_mth_ret_hdr_h
196: (HEADER_ID,
197: ORG_ID,
198: CIS_SENDER_ID,
199: TAX_OFFICE_NUMBER,