APPS.FUN_GL_BATCH_TRANSFER dependencies on GL_INTERFACE

Line 82: from gl_interface

78: --journal import cursor to be modified
79:
80: cursor c_import(p_concreqid number, p_source VARCHAR2, p_category VARCHAR2) is
81: select distinct ledger_id
82: from gl_interface
83: where user_je_category_name = p_category
84: and user_je_source_name = p_source
85: and request_id=p_concreqid;
86:

Line 314: insert_clause := 'INSERT INTO GL_INTERFACE

310: END;
311:
312: -- Bug 7173185. Changed the query to populate the REFERENCE4 column also.
313: /* Insert data into temp table ends here */
314: insert_clause := 'INSERT INTO GL_INTERFACE
315: (STATUS,
316: GROUP_ID,
317: SET_OF_BOOKS_ID,
318: ACCOUNTING_DATE,

Line 393: --Insert into GL_INTERFACE table.

389: TRXB.EXCHANGE_RATE_TYPE,TRUNC(TRXB.BATCH_DATE)) = 1';
390:
391: l_cur_main_query := l_cur_select||l_cur_where;
392:
393: --Insert into GL_INTERFACE table.
394: EXECUTE IMMEDIATE insert_clause || select_clause || where_clause;
395:
396: WF_EVENT.AddParameterToList(p_name=>'INIT_SYS_DATE',
397: p_value=>l_init_sysdate,

Line 446: insert into gl_interface_control (je_source_name,

442: loop
443: -- get interface run id
444: select gl_journal_import_s.nextval into v_interface_run_id from dual;
445:
446: insert into gl_interface_control (je_source_name,
447: status,
448: set_of_books_id,
449: group_id,
450: interface_run_id)