APPS.IGI_ITR dependencies on IGI_ITR

Line 1: PACKAGE BODY IGI_ITR AS

1: PACKAGE BODY IGI_ITR AS
2: -- $Header: igiitrgb.pls 120.3.12000000.1 2007/09/12 10:31:04 mbremkum ship $
3: --
4: PROCEDURE action (p_action NUMBER)
5: AS

Line 28: IGI_itr.STATUS(l_BatchIdTable(l_Var));

24: THEN
25: FOR I in 1..l_TableRow
26: LOOP
27: l_Var := l_Var + 1;
28: IGI_itr.STATUS(l_BatchIdTable(l_Var));
29: END LOOP;
30: END IF;
31: END process_batches;
32: --

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 98: R_igi_itr_charge_lines IGI_itr_charge_lines%ROWTYPE;

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);
102: interface_sequence_num number;

Line 112: FROM IGI_itr_charge_lines

108: flag number := 0;
109:
110: CURSOR c1 is
111: SELECT *
112: FROM IGI_itr_charge_lines
113: WHERE it_header_id = p_it_header_id
114: AND status_flag is null
115: AND posting_flag is null;
116:

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 184: FETCH c1 INTO R_igi_itr_charge_lines;

180: ,interface_group_id
181: );
182: OPEN c1;
183: LOOP
184: FETCH c1 INTO R_igi_itr_charge_lines;
185: EXIT WHEN c1%NOTFOUND;
186:
187: INSERT INTO gl_interface
188: (status

Line 210: ,R_igi_itr_charge_lines.entered_dr

206: ,reference22
207: ,group_id
208: )
209: VALUES ('NEW'
210: ,R_igi_itr_charge_lines.entered_dr
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

Line 211: ,R_igi_itr_charge_lines.entered_cr

207: ,group_id
208: )
209: VALUES ('NEW'
210: ,R_igi_itr_charge_lines.entered_dr
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

Line 212: ,R_igi_itr_charge_lines.set_of_books_id

208: )
209: VALUES ('NEW'
210: ,R_igi_itr_charge_lines.entered_dr
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

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 217: ,R_igi_itr_charge_lines.creation_date

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
221: ,R_igi_itr_charge_lines.code_combination_id

Line 218: ,R_igi_itr_charge_lines.created_by

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
221: ,R_igi_itr_charge_lines.code_combination_id
222: ,R_igi_itr_charge_headers.name

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 221: ,R_igi_itr_charge_lines.code_combination_id

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
225: ,R_igi_itr_charge_lines.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 225: ,R_igi_itr_charge_lines.description

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
229: );

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 227: ,R_igi_itr_charge_lines.it_line_num

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;
231: CLOSE c1;

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 294: R_line igi_itr_charge_lines%rowtype;

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
298: insert into gl_interface

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 391: from IGI_itr_charge_lines

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
392: where it_header_id = p_it_header_id
393: and it_line_num = p_it_line_num;
394:
395: select user_je_source_name into m_user_je_source_name

Line 405: IGI_ITR.REJECT(R_header.it_header_id

401: where je_category_name = R_header.it_category;
402:
403: if (p_igig_itr_encumbrance_allowed = 'Y') then
404:
405: IGI_ITR.REJECT(R_header.it_header_id
406: ,R_line.it_line_num
407: ,p_group_id
408: ,p_status_code
409: ,p_status_message

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 435: R_line IGI_itr_charge_lines%rowtype;

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
439: from IGI_itr_charge_headers

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 443: from IGI_itr_charge_lines

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
444: where it_header_id = p_it_header_id
445: and it_line_num = p_it_line_num;
446:
447: select user_je_source_name into m_user_je_source_name

Line 583: from IGI_itr_charge_lines

579: begin
580: if (current_line.reference_1 is not null) and
581: (current_line.reference_2 is not null) then
582: select status_flag, posting_flag into l_status_flag, l_posting_flag
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

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 606: UPDATE IGI_itr_charge_lines

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
607: SET posting_flag = 'F'
608: WHERE it_header_id = current_line.reference_1
609: AND it_line_num = current_line.reference_2;
610: end if;

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 631: UPDATE IGI_itr_charge_lines

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
632: SET posting_flag = 'D'
633: WHERE it_header_id = current_line.reference_1
634: AND it_line_num = current_line.reference_2;
635: end if;

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 655: UPDATE IGI_itr_charge_lines

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
656: SET posting_flag = 'O'
657: WHERE it_header_id = current_line.reference_1
658: AND it_line_num = current_line.reference_2;
659: end if;

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 677: UPDATE IGI_itr_charge_lines

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
678: SET posting_flag = 'D'
679: WHERE it_header_id = current_line.reference_1
680: AND it_line_num = current_line.reference_2;
681: end if;

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 699: UPDATE IGI_itr_charge_lines

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
700: SET posting_flag = 'O'
701: WHERE it_header_id = current_line.reference_1
702: AND it_line_num = current_line.reference_2;
703: end if;

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 718: UPDATE IGI_itr_charge_lines

714: WHERE it_header_id = current_line.reference_1;
715: else
716: if (l_posting_flag = 'S' OR l_posting_flag = 'P')
717: then
718: UPDATE IGI_itr_charge_lines
719: SET posting_flag = 'P'
720: WHERE it_header_id = current_line.reference_1
721: AND it_line_num = current_line.reference_2;
722:

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

Line 727: from IGI_itr_charge_lines

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
728: where it_header_id = current_line.reference_1)
729: AND b_actual_flag = 'A';
730: end if;
731: end if;

Line 744: end IGI_ITR;

740: WHEN NO_DATA_FOUND THEN
741: NULL;
742: end STATUS;
743:
744: end IGI_ITR;