DBA Data[Home] [Help]

APPS.IGI_ITR dependencies on GL_INTERFACE

Line 44: INSERT INTO gl_interface_control ( je_source_name

40: AS
41: import_request_id number;
42:
43: BEGIN
44: INSERT INTO gl_interface_control ( je_source_name
45: , status
46: , interface_run_id
47: , group_id
48: , set_of_books_id

Line 139: INSERT INTO gl_interface

135: IF (m_submit_flag = 'S' or m_submit_flag = 'R') THEN
136: SELECT gl_journal_import_s.nextval
137: INTO interface_group_id
138: FROM dual;
139: INSERT INTO gl_interface
140: (status
141: ,entered_dr
142: ,entered_cr
143: ,set_of_books_id

Line 187: INSERT INTO gl_interface

183: LOOP
184: FETCH c1 INTO R_igi_itr_charge_lines;
185: EXIT WHEN c1%NOTFOUND;
186:
187: INSERT INTO gl_interface
188: (status
189: ,entered_dr
190: ,entered_cr
191: ,set_of_books_id

Line 238: INSERT INTO gl_interface_control

234: SELECT gl_journal_import_s.nextval
235: INTO interface_sequence_num
236: FROM dual;
237:
238: INSERT INTO gl_interface_control
239: (je_source_name
240: ,status
241: ,interface_run_id
242: ,group_id

Line 298: insert into gl_interface

294: R_line igi_itr_charge_lines%rowtype;
295:
296: PROCEDURE ACTUAL is
297: begin
298: insert into gl_interface
299: (status
300: ,entered_dr
301: ,entered_cr
302: ,set_of_books_id

Line 341: insert into gl_interface

337: ,p_it_header_id
338: ,p_it_line_num
339: ,p_group_id
340: );
341: insert into gl_interface
342: (status
343: ,entered_dr
344: ,entered_cr
345: ,set_of_books_id

Line 455: insert into gl_interface

451: select user_je_category_name into m_user_je_category_name
452: from gl_je_categories
453: where je_category_name = R_header.it_category;
454:
455: insert into gl_interface
456: (status
457: ,entered_dr
458: ,entered_cr
459: ,set_of_books_id

Line 498: insert into gl_interface

494: ,p_it_header_id
495: ,p_it_line_num
496: ,p_group_id
497: );
498: insert into gl_interface
499: (status
500: ,entered_dr
501: ,entered_cr
502: ,set_of_books_id