APPS.FUN_GL_BATCH_TRANSFER dependencies on GL_INTERFACE

Line 90: from gl_interface

86: --journal import cursor to be modified
87:
88: cursor c_import(p_concreqid number, p_source VARCHAR2, p_category VARCHAR2) is
89: select distinct ledger_id
90: from gl_interface
91: where user_je_category_name = p_category
92: and user_je_source_name = p_source
93: and request_id=p_concreqid;
94:

Line 322: insert_clause := 'INSERT INTO GL_INTERFACE

318: END;
319:
320: -- Bug 7173185. Changed the query to populate the REFERENCE4 column also.
321: /* Insert data into temp table ends here */
322: insert_clause := 'INSERT INTO GL_INTERFACE
323: (STATUS,
324: GROUP_ID,
325: SET_OF_BOOKS_ID,
326: ACCOUNTING_DATE,

Line 403: --Insert into GL_INTERFACE table.

399: TRXB.EXCHANGE_RATE_TYPE,TRUNC(TRXB.GL_DATE)) = 1';
400:
401: l_cur_main_query := l_cur_select||l_cur_where;
402:
403: --Insert into GL_INTERFACE table.
404: EXECUTE IMMEDIATE insert_clause || select_clause || where_clause;
405:
406: WF_EVENT.AddParameterToList(p_name=>'INIT_SYS_DATE',
407: p_value=>l_init_sysdate,

Line 456: insert into gl_interface_control (je_source_name,

452: loop
453: -- get interface run id
454: select gl_journal_import_s.nextval into v_interface_run_id from dual;
455:
456: insert into gl_interface_control (je_source_name,
457: status,
458: set_of_books_id,
459: group_id,
460: interface_run_id)