DBA Data[Home] [Help]

APPS.CE_XML_BS_LOADER dependencies on CE_XML_STATEMENT_LIST

Line 9: from ce_xml_statement_list;

5: select item_key,
6: statement_number,
7: trading_partner,
8: bank_account_num
9: from ce_xml_statement_list;
10:
11: PROCEDURE SETUP_IMPORT(
12: X_STATEMENT_NUMBER IN VARCHAR2,
13: X_BANK_ACCOUNT_NUM IN VARCHAR2,

Line 18: insert into CE_XML_STATEMENT_LIST

14: X_TRADING_PARTNER IN VARCHAR2,
15: X_ITEM_KEY IN VARCHAR2) IS
16:
17: BEGIN
18: insert into CE_XML_STATEMENT_LIST
19: (ITEM_KEY, STATEMENT_NUMBER, TRADING_PARTNER, BANK_ACCOUNT_NUM)
20: values (
21: X_ITEM_KEY,
22: X_STATEMENT_NUMBER,

Line 56: DELETE ce_xml_statement_list

52: l_bank_account_num;
53: EXIT WHEN get_statements_cursor%NOTFOUND OR
54: get_statements_cursor%NOTFOUND is null;
55:
56: DELETE ce_xml_statement_list
57: WHERE item_key = l_item_key;
58:
59: WF_ENGINE.createProcess('CEXMLBSL', l_item_key, 'CE_XML_BSL');
60: