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
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
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
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
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
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
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
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