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_ITR dependencies on IGI_ITR_CHARGE_HEADERS

Line 97: R_igi_itr_charge_headers IGI_itr_charge_headers%ROWTYPE;

93: (P_IT_HEADER_ID number,
94: P_STATUS_FLAG IN OUT NOCOPY number, P_STATUS_MESSAGE IN OUT NOCOPY VARCHAR2)
95: AS
96:
97: R_igi_itr_charge_headers IGI_itr_charge_headers%ROWTYPE;
98: R_igi_itr_charge_lines IGI_itr_charge_lines%ROWTYPE;
99:
100: m_user_je_category_name varchar2(25);
101: m_user_je_source_name varchar2(25);

Line 120: FROM IGI_itr_charge_headers

116:
117:
118: BEGIN
119: SELECT submit_flag into m_submit_flag
120: FROM IGI_itr_charge_headers
121: WHERE it_header_id = p_it_header_id;
122:
123: SELECT * into R_igi_itr_charge_headers
124: FROM IGI_itr_charge_headers

Line 123: SELECT * into R_igi_itr_charge_headers

119: SELECT submit_flag into m_submit_flag
120: FROM IGI_itr_charge_headers
121: WHERE it_header_id = p_it_header_id;
122:
123: SELECT * into R_igi_itr_charge_headers
124: FROM IGI_itr_charge_headers
125: WHERE it_header_id = p_it_header_id;
126:
127: SELECT user_je_source_name into m_user_je_source_name

Line 124: FROM IGI_itr_charge_headers

120: FROM IGI_itr_charge_headers
121: WHERE it_header_id = p_it_header_id;
122:
123: SELECT * into R_igi_itr_charge_headers
124: FROM IGI_itr_charge_headers
125: WHERE it_header_id = p_it_header_id;
126:
127: SELECT user_je_source_name into m_user_je_source_name
128: FROM gl_je_sources

Line 129: WHERE je_source_name = R_igi_itr_charge_headers.it_source;

125: WHERE it_header_id = p_it_header_id;
126:
127: SELECT user_je_source_name into m_user_je_source_name
128: FROM gl_je_sources
129: WHERE je_source_name = R_igi_itr_charge_headers.it_source;
130:
131: SELECT user_je_category_name into m_user_je_category_name
132: FROM gl_je_categories
133: WHERE je_category_name = R_igi_itr_charge_headers.it_category;

Line 133: WHERE je_category_name = R_igi_itr_charge_headers.it_category;

129: WHERE je_source_name = R_igi_itr_charge_headers.it_source;
130:
131: SELECT user_je_category_name into m_user_je_category_name
132: FROM gl_je_categories
133: WHERE je_category_name = R_igi_itr_charge_headers.it_category;
134:
135: IF (m_submit_flag = 'S' or m_submit_flag = 'R') THEN
136: SELECT gl_journal_import_s.nextval
137: INTO interface_group_id

Line 162: ,R_igi_itr_charge_headers.entered_dr

158: ,reference22
159: ,group_id
160: )
161: VALUES ('NEW'
162: ,R_igi_itr_charge_headers.entered_dr
163: ,R_igi_itr_charge_headers.entered_cr
164: ,R_igi_itr_charge_headers.set_of_books_id
165: ,m_user_je_source_name
166: ,m_user_je_category_name

Line 163: ,R_igi_itr_charge_headers.entered_cr

159: ,group_id
160: )
161: VALUES ('NEW'
162: ,R_igi_itr_charge_headers.entered_dr
163: ,R_igi_itr_charge_headers.entered_cr
164: ,R_igi_itr_charge_headers.set_of_books_id
165: ,m_user_je_source_name
166: ,m_user_je_category_name
167: ,R_igi_itr_charge_headers.gl_date

Line 164: ,R_igi_itr_charge_headers.set_of_books_id

160: )
161: VALUES ('NEW'
162: ,R_igi_itr_charge_headers.entered_dr
163: ,R_igi_itr_charge_headers.entered_cr
164: ,R_igi_itr_charge_headers.set_of_books_id
165: ,m_user_je_source_name
166: ,m_user_je_category_name
167: ,R_igi_itr_charge_headers.gl_date
168: ,R_igi_itr_charge_headers.currency_code

Line 167: ,R_igi_itr_charge_headers.gl_date

163: ,R_igi_itr_charge_headers.entered_cr
164: ,R_igi_itr_charge_headers.set_of_books_id
165: ,m_user_je_source_name
166: ,m_user_je_category_name
167: ,R_igi_itr_charge_headers.gl_date
168: ,R_igi_itr_charge_headers.currency_code
169: ,R_igi_itr_charge_headers.creation_date
170: ,R_igi_itr_charge_headers.created_by
171: ,'E'

Line 168: ,R_igi_itr_charge_headers.currency_code

164: ,R_igi_itr_charge_headers.set_of_books_id
165: ,m_user_je_source_name
166: ,m_user_je_category_name
167: ,R_igi_itr_charge_headers.gl_date
168: ,R_igi_itr_charge_headers.currency_code
169: ,R_igi_itr_charge_headers.creation_date
170: ,R_igi_itr_charge_headers.created_by
171: ,'E'
172: ,R_igi_itr_charge_headers.encumbrance_type_id

Line 169: ,R_igi_itr_charge_headers.creation_date

165: ,m_user_je_source_name
166: ,m_user_je_category_name
167: ,R_igi_itr_charge_headers.gl_date
168: ,R_igi_itr_charge_headers.currency_code
169: ,R_igi_itr_charge_headers.creation_date
170: ,R_igi_itr_charge_headers.created_by
171: ,'E'
172: ,R_igi_itr_charge_headers.encumbrance_type_id
173: ,R_igi_itr_charge_headers.code_combination_id

Line 170: ,R_igi_itr_charge_headers.created_by

166: ,m_user_je_category_name
167: ,R_igi_itr_charge_headers.gl_date
168: ,R_igi_itr_charge_headers.currency_code
169: ,R_igi_itr_charge_headers.creation_date
170: ,R_igi_itr_charge_headers.created_by
171: ,'E'
172: ,R_igi_itr_charge_headers.encumbrance_type_id
173: ,R_igi_itr_charge_headers.code_combination_id
174: ,R_igi_itr_charge_headers.name

Line 172: ,R_igi_itr_charge_headers.encumbrance_type_id

168: ,R_igi_itr_charge_headers.currency_code
169: ,R_igi_itr_charge_headers.creation_date
170: ,R_igi_itr_charge_headers.created_by
171: ,'E'
172: ,R_igi_itr_charge_headers.encumbrance_type_id
173: ,R_igi_itr_charge_headers.code_combination_id
174: ,R_igi_itr_charge_headers.name
175: ,R_igi_itr_charge_headers.name
176: ,R_igi_itr_charge_headers.description

Line 173: ,R_igi_itr_charge_headers.code_combination_id

169: ,R_igi_itr_charge_headers.creation_date
170: ,R_igi_itr_charge_headers.created_by
171: ,'E'
172: ,R_igi_itr_charge_headers.encumbrance_type_id
173: ,R_igi_itr_charge_headers.code_combination_id
174: ,R_igi_itr_charge_headers.name
175: ,R_igi_itr_charge_headers.name
176: ,R_igi_itr_charge_headers.description
177: ,R_igi_itr_charge_headers.description

Line 174: ,R_igi_itr_charge_headers.name

170: ,R_igi_itr_charge_headers.created_by
171: ,'E'
172: ,R_igi_itr_charge_headers.encumbrance_type_id
173: ,R_igi_itr_charge_headers.code_combination_id
174: ,R_igi_itr_charge_headers.name
175: ,R_igi_itr_charge_headers.name
176: ,R_igi_itr_charge_headers.description
177: ,R_igi_itr_charge_headers.description
178: ,R_igi_itr_charge_headers.it_header_id

Line 175: ,R_igi_itr_charge_headers.name

171: ,'E'
172: ,R_igi_itr_charge_headers.encumbrance_type_id
173: ,R_igi_itr_charge_headers.code_combination_id
174: ,R_igi_itr_charge_headers.name
175: ,R_igi_itr_charge_headers.name
176: ,R_igi_itr_charge_headers.description
177: ,R_igi_itr_charge_headers.description
178: ,R_igi_itr_charge_headers.it_header_id
179: ,NULL

Line 176: ,R_igi_itr_charge_headers.description

172: ,R_igi_itr_charge_headers.encumbrance_type_id
173: ,R_igi_itr_charge_headers.code_combination_id
174: ,R_igi_itr_charge_headers.name
175: ,R_igi_itr_charge_headers.name
176: ,R_igi_itr_charge_headers.description
177: ,R_igi_itr_charge_headers.description
178: ,R_igi_itr_charge_headers.it_header_id
179: ,NULL
180: ,interface_group_id

Line 177: ,R_igi_itr_charge_headers.description

173: ,R_igi_itr_charge_headers.code_combination_id
174: ,R_igi_itr_charge_headers.name
175: ,R_igi_itr_charge_headers.name
176: ,R_igi_itr_charge_headers.description
177: ,R_igi_itr_charge_headers.description
178: ,R_igi_itr_charge_headers.it_header_id
179: ,NULL
180: ,interface_group_id
181: );

Line 178: ,R_igi_itr_charge_headers.it_header_id

174: ,R_igi_itr_charge_headers.name
175: ,R_igi_itr_charge_headers.name
176: ,R_igi_itr_charge_headers.description
177: ,R_igi_itr_charge_headers.description
178: ,R_igi_itr_charge_headers.it_header_id
179: ,NULL
180: ,interface_group_id
181: );
182: OPEN c1;

Line 215: ,R_igi_itr_charge_headers.gl_date

211: ,R_igi_itr_charge_lines.entered_cr
212: ,R_igi_itr_charge_lines.set_of_books_id
213: ,m_user_je_source_name
214: ,m_user_je_category_name
215: ,R_igi_itr_charge_headers.gl_date
216: ,R_igi_itr_charge_headers.currency_code
217: ,R_igi_itr_charge_lines.creation_date
218: ,R_igi_itr_charge_lines.created_by
219: ,'E'

Line 216: ,R_igi_itr_charge_headers.currency_code

212: ,R_igi_itr_charge_lines.set_of_books_id
213: ,m_user_je_source_name
214: ,m_user_je_category_name
215: ,R_igi_itr_charge_headers.gl_date
216: ,R_igi_itr_charge_headers.currency_code
217: ,R_igi_itr_charge_lines.creation_date
218: ,R_igi_itr_charge_lines.created_by
219: ,'E'
220: ,R_igi_itr_charge_headers.encumbrance_type_id

Line 220: ,R_igi_itr_charge_headers.encumbrance_type_id

216: ,R_igi_itr_charge_headers.currency_code
217: ,R_igi_itr_charge_lines.creation_date
218: ,R_igi_itr_charge_lines.created_by
219: ,'E'
220: ,R_igi_itr_charge_headers.encumbrance_type_id
221: ,R_igi_itr_charge_lines.code_combination_id
222: ,R_igi_itr_charge_headers.name
223: ,R_igi_itr_charge_headers.name
224: ,R_igi_itr_charge_headers.description

Line 222: ,R_igi_itr_charge_headers.name

218: ,R_igi_itr_charge_lines.created_by
219: ,'E'
220: ,R_igi_itr_charge_headers.encumbrance_type_id
221: ,R_igi_itr_charge_lines.code_combination_id
222: ,R_igi_itr_charge_headers.name
223: ,R_igi_itr_charge_headers.name
224: ,R_igi_itr_charge_headers.description
225: ,R_igi_itr_charge_lines.description
226: ,R_igi_itr_charge_headers.it_header_id

Line 223: ,R_igi_itr_charge_headers.name

219: ,'E'
220: ,R_igi_itr_charge_headers.encumbrance_type_id
221: ,R_igi_itr_charge_lines.code_combination_id
222: ,R_igi_itr_charge_headers.name
223: ,R_igi_itr_charge_headers.name
224: ,R_igi_itr_charge_headers.description
225: ,R_igi_itr_charge_lines.description
226: ,R_igi_itr_charge_headers.it_header_id
227: ,R_igi_itr_charge_lines.it_line_num

Line 224: ,R_igi_itr_charge_headers.description

220: ,R_igi_itr_charge_headers.encumbrance_type_id
221: ,R_igi_itr_charge_lines.code_combination_id
222: ,R_igi_itr_charge_headers.name
223: ,R_igi_itr_charge_headers.name
224: ,R_igi_itr_charge_headers.description
225: ,R_igi_itr_charge_lines.description
226: ,R_igi_itr_charge_headers.it_header_id
227: ,R_igi_itr_charge_lines.it_line_num
228: ,interface_group_id

Line 226: ,R_igi_itr_charge_headers.it_header_id

222: ,R_igi_itr_charge_headers.name
223: ,R_igi_itr_charge_headers.name
224: ,R_igi_itr_charge_headers.description
225: ,R_igi_itr_charge_lines.description
226: ,R_igi_itr_charge_headers.it_header_id
227: ,R_igi_itr_charge_lines.it_line_num
228: ,interface_group_id
229: );
230: END LOOP;

Line 249: ,R_igi_itr_charge_headers.set_of_books_id

245: ('Internal Trading'
246: ,'S'
247: ,interface_sequence_num
248: ,interface_group_id
249: ,R_igi_itr_charge_headers.set_of_books_id
250: );
251:
252: import_request_id := FND_REQUEST.SUBMIT_REQUEST
253: ('SQLGL'

Line 259: ,R_igi_itr_charge_headers.set_of_books_id

255: , NULL
256: , NULL
257: , FALSE
258: , interface_sequence_num
259: ,R_igi_itr_charge_headers.set_of_books_id
260: , 'N'
261: , null
262: , null
263: , 'N'

Line 293: R_header igi_itr_charge_headers%rowtype;

289:
290: m_user_je_category_name varchar2(25);
291: m_user_je_source_name varchar2(25);
292:
293: R_header igi_itr_charge_headers%rowtype;
294: R_line igi_itr_charge_lines%rowtype;
295:
296: PROCEDURE ACTUAL is
297: begin

Line 387: from IGI_itr_charge_headers

383: );
384: end;
385: begin
386: select * into R_header
387: from IGI_itr_charge_headers
388: where it_header_id = p_it_header_id;
389:
390: select * into R_line
391: from IGI_itr_charge_lines

Line 434: R_header IGI_itr_charge_headers%rowtype;

430:
431: m_user_je_category_name varchar2(25);
432: m_user_je_source_name varchar2(25);
433:
434: R_header IGI_itr_charge_headers%rowtype;
435: R_line IGI_itr_charge_lines%rowtype;
436:
437: begin
438: select * into R_header

Line 439: from IGI_itr_charge_headers

435: R_line IGI_itr_charge_lines%rowtype;
436:
437: begin
438: select * into R_header
439: from IGI_itr_charge_headers
440: where it_header_id = p_it_header_id;
441:
442: select * into R_line
443: from IGI_itr_charge_lines

Line 587: select 1 into a from IGI_itr_charge_headers

583: from IGI_itr_charge_lines
584: where it_header_id = current_line.reference_1 and
585: it_line_num = current_line.reference_2;
586: else
587: select 1 into a from IGI_itr_charge_headers
588: where it_header_id = current_line.reference_1;
589: l_status_flag := NULL;
590: end if;
591: EXCEPTION

Line 602: UPDATE IGI_itr_charge_headers

598: if b_budgetary_control_status = 'F'
599: then
600: if l_status_flag IS NULL
601: then
602: UPDATE IGI_itr_charge_headers
603: SET submit_flag = 'F'
604: WHERE it_header_id = current_line.reference_1;
605: else
606: UPDATE IGI_itr_charge_lines

Line 627: UPDATE IGI_itr_charge_headers

623:
624: then
625: if l_status_flag IS NULL
626: then
627: UPDATE IGI_itr_charge_headers
628: SET submit_flag = 'D'
629: WHERE it_header_id = current_line.reference_1;
630: else
631: UPDATE IGI_itr_charge_lines

Line 651: UPDATE IGI_itr_charge_headers

647:
648: then
649: if l_status_flag IS NULL
650: then
651: UPDATE IGI_itr_charge_headers
652: SET submit_flag = 'O'
653: WHERE it_header_id = current_line.reference_1;
654: else
655: UPDATE IGI_itr_charge_lines

Line 673: UPDATE IGI_itr_charge_headers

669: elsif b_budgetary_control_status = 'N'
670: then
671: if l_status_flag IS NULL
672: then
673: UPDATE IGI_itr_charge_headers
674: SET submit_flag = 'D'
675: WHERE it_header_id = current_line.reference_1;
676: else
677: UPDATE IGI_itr_charge_lines

Line 695: UPDATE IGI_itr_charge_headers

691: elsif b_budgetary_control_status = 'P'
692: then
693: if l_status_flag IS NULL
694: then
695: UPDATE IGI_itr_charge_headers
696: SET submit_flag = 'O'
697: WHERE it_header_id = current_line.reference_1;
698: else
699: UPDATE IGI_itr_charge_lines

Line 712: UPDATE IGI_itr_charge_headers

708: elsif b_status_flag = 'P'
709: then
710: if l_status_flag IS NULL
711: then
712: UPDATE IGI_itr_charge_headers
713: SET submit_flag = 'P'
714: WHERE it_header_id = current_line.reference_1;
715: else
716: if (l_posting_flag = 'S' OR l_posting_flag = 'P')

Line 723: UPDATE IGI_itr_charge_headers

719: SET posting_flag = 'P'
720: WHERE it_header_id = current_line.reference_1
721: AND it_line_num = current_line.reference_2;
722:
723: UPDATE IGI_itr_charge_headers
724: set submit_flag = 'C' where
725: it_header_id = current_line.reference_1
726: and ('A','P') =all (select status_flag,posting_flag
727: from IGI_itr_charge_lines