APPS.CE_PURGE dependencies on CE_BANK_ACCOUNTS

Line 8: G_BANK_ACCOUNT_ID ce_bank_accounts.BANK_ACCOUNT_ID%TYPE;

4: -- GLOBAL variables
5: --
6:
7:
8: G_BANK_ACCOUNT_ID ce_bank_accounts.BANK_ACCOUNT_ID%TYPE;
9: G_BANK_BRANCH_ID ce_bank_accounts.BANK_branch_ID%TYPE;
10: G_STATEMENT_DATE_FROM ce_statement_headers.statement_date%TYPE;
11: G_STATEMENT_DATE_TO ce_statement_headers.statement_date%TYPE;
12: G_Bank_Name ce_bank_branches_v.bank_name%TYPE;

Line 9: G_BANK_BRANCH_ID ce_bank_accounts.BANK_branch_ID%TYPE;

5: --
6:
7:
8: G_BANK_ACCOUNT_ID ce_bank_accounts.BANK_ACCOUNT_ID%TYPE;
9: G_BANK_BRANCH_ID ce_bank_accounts.BANK_branch_ID%TYPE;
10: G_STATEMENT_DATE_FROM ce_statement_headers.statement_date%TYPE;
11: G_STATEMENT_DATE_TO ce_statement_headers.statement_date%TYPE;
12: G_Bank_Name ce_bank_branches_v.bank_name%TYPE;
13: G_Bank_Branch_Name ce_bank_branches_v.bank_branch_name%TYPE;

Line 14: G_BANK_ACCOUNT_Name ce_bank_accounts.Bank_Account_Name%TYPE;

10: G_STATEMENT_DATE_FROM ce_statement_headers.statement_date%TYPE;
11: G_STATEMENT_DATE_TO ce_statement_headers.statement_date%TYPE;
12: G_Bank_Name ce_bank_branches_v.bank_name%TYPE;
13: G_Bank_Branch_Name ce_bank_branches_v.bank_branch_name%TYPE;
14: G_BANK_ACCOUNT_Name ce_bank_accounts.Bank_Account_Name%TYPE;
15: G_Currency_Code ce_bank_accounts.Currency_Code%TYPE;
16: G_BANK_ACCOUNT_Num ce_bank_accounts.Bank_Account_Num%TYPE;
17: G_Archive_Purge_Option VARCHAR2(30);
18: G_Delete_Or_Append_Action VARCHAR2(30);

Line 15: G_Currency_Code ce_bank_accounts.Currency_Code%TYPE;

11: G_STATEMENT_DATE_TO ce_statement_headers.statement_date%TYPE;
12: G_Bank_Name ce_bank_branches_v.bank_name%TYPE;
13: G_Bank_Branch_Name ce_bank_branches_v.bank_branch_name%TYPE;
14: G_BANK_ACCOUNT_Name ce_bank_accounts.Bank_Account_Name%TYPE;
15: G_Currency_Code ce_bank_accounts.Currency_Code%TYPE;
16: G_BANK_ACCOUNT_Num ce_bank_accounts.Bank_Account_Num%TYPE;
17: G_Archive_Purge_Option VARCHAR2(30);
18: G_Delete_Or_Append_Action VARCHAR2(30);
19: G_Objects VARCHAR2(30);

Line 16: G_BANK_ACCOUNT_Num ce_bank_accounts.Bank_Account_Num%TYPE;

12: G_Bank_Name ce_bank_branches_v.bank_name%TYPE;
13: G_Bank_Branch_Name ce_bank_branches_v.bank_branch_name%TYPE;
14: G_BANK_ACCOUNT_Name ce_bank_accounts.Bank_Account_Name%TYPE;
15: G_Currency_Code ce_bank_accounts.Currency_Code%TYPE;
16: G_BANK_ACCOUNT_Num ce_bank_accounts.Bank_Account_Num%TYPE;
17: G_Archive_Purge_Option VARCHAR2(30);
18: G_Delete_Or_Append_Action VARCHAR2(30);
19: G_Objects VARCHAR2(30);
20: G_Statement_type VARCHAR2(30);

Line 47: p_BANK_ACCOUNT_ID ce_bank_accounts.BANK_ACCOUNT_ID%TYPE,

43: G_Archive_Stat_Lines2 NUMBER := 0;
44: G_Archive_Stat_Headers2 NUMBER := 0;
45:
46: PROCEDURE set_parameters(
47: p_BANK_ACCOUNT_ID ce_bank_accounts.BANK_ACCOUNT_ID%TYPE,
48: p_BANK_BRANCH_ID ce_bank_accounts.BANK_branch_ID%TYPE,
49: p_STATEMENT_DATE_FROM ce_statement_headers.statement_date%TYPE,
50: p_STATEMENT_DATE_TO ce_statement_headers.statement_date%TYPE,
51: p_Bank_Name ce_bank_branches_v.bank_name%TYPE,

Line 48: p_BANK_BRANCH_ID ce_bank_accounts.BANK_branch_ID%TYPE,

44: G_Archive_Stat_Headers2 NUMBER := 0;
45:
46: PROCEDURE set_parameters(
47: p_BANK_ACCOUNT_ID ce_bank_accounts.BANK_ACCOUNT_ID%TYPE,
48: p_BANK_BRANCH_ID ce_bank_accounts.BANK_branch_ID%TYPE,
49: p_STATEMENT_DATE_FROM ce_statement_headers.statement_date%TYPE,
50: p_STATEMENT_DATE_TO ce_statement_headers.statement_date%TYPE,
51: p_Bank_Name ce_bank_branches_v.bank_name%TYPE,
52: p_Bank_Branch_Name ce_bank_branches_v.bank_branch_name%TYPE,

Line 53: p_Bank_Account_Name ce_bank_accounts.Bank_Account_Name%TYPE,

49: p_STATEMENT_DATE_FROM ce_statement_headers.statement_date%TYPE,
50: p_STATEMENT_DATE_TO ce_statement_headers.statement_date%TYPE,
51: p_Bank_Name ce_bank_branches_v.bank_name%TYPE,
52: p_Bank_Branch_Name ce_bank_branches_v.bank_branch_name%TYPE,
53: p_Bank_Account_Name ce_bank_accounts.Bank_Account_Name%TYPE,
54: p_Currency_Code ce_bank_accounts.Currency_Code%TYPE,
55: p_Bank_Account_Num ce_bank_accounts.Bank_Account_Num%TYPE,
56: p_Archive_Purge_Option VARCHAR2,
57: p_Delete_Or_Append_Action VARCHAR2,

Line 54: p_Currency_Code ce_bank_accounts.Currency_Code%TYPE,

50: p_STATEMENT_DATE_TO ce_statement_headers.statement_date%TYPE,
51: p_Bank_Name ce_bank_branches_v.bank_name%TYPE,
52: p_Bank_Branch_Name ce_bank_branches_v.bank_branch_name%TYPE,
53: p_Bank_Account_Name ce_bank_accounts.Bank_Account_Name%TYPE,
54: p_Currency_Code ce_bank_accounts.Currency_Code%TYPE,
55: p_Bank_Account_Num ce_bank_accounts.Bank_Account_Num%TYPE,
56: p_Archive_Purge_Option VARCHAR2,
57: p_Delete_Or_Append_Action VARCHAR2,
58: p_Objects VARCHAR2,

Line 55: p_Bank_Account_Num ce_bank_accounts.Bank_Account_Num%TYPE,

51: p_Bank_Name ce_bank_branches_v.bank_name%TYPE,
52: p_Bank_Branch_Name ce_bank_branches_v.bank_branch_name%TYPE,
53: p_Bank_Account_Name ce_bank_accounts.Bank_Account_Name%TYPE,
54: p_Currency_Code ce_bank_accounts.Currency_Code%TYPE,
55: p_Bank_Account_Num ce_bank_accounts.Bank_Account_Num%TYPE,
56: p_Archive_Purge_Option VARCHAR2,
57: p_Delete_Or_Append_Action VARCHAR2,
58: p_Objects VARCHAR2,
59: p_Statement_type VARCHAR2,

Line 102: p_BANK_BRANCH_ID IN ce_bank_accounts.BANK_branch_ID%TYPE,

98: retcode OUT NOCOPY NUMBER,
99: p_Objects IN VARCHAR2,
100: p_Statement_type IN VARCHAR2,
101: p_hdr_int_status IN VARCHAR2,
102: p_BANK_BRANCH_ID IN ce_bank_accounts.BANK_branch_ID%TYPE,
103: p_BANK_ACCOUNT_ID IN ce_bank_accounts.BANK_ACCOUNT_ID%TYPE,
104: p_STATEMENT_DATE_FROM IN VARCHAR2,
105: p_STATEMENT_DATE_TO IN VARCHAR2 ,
106: X_sql_trace IN VARCHAR2 ,

Line 103: p_BANK_ACCOUNT_ID IN ce_bank_accounts.BANK_ACCOUNT_ID%TYPE,

99: p_Objects IN VARCHAR2,
100: p_Statement_type IN VARCHAR2,
101: p_hdr_int_status IN VARCHAR2,
102: p_BANK_BRANCH_ID IN ce_bank_accounts.BANK_branch_ID%TYPE,
103: p_BANK_ACCOUNT_ID IN ce_bank_accounts.BANK_ACCOUNT_ID%TYPE,
104: p_STATEMENT_DATE_FROM IN VARCHAR2,
105: p_STATEMENT_DATE_TO IN VARCHAR2 ,
106: X_sql_trace IN VARCHAR2 ,
107: X_debug_path IN VARCHAR2