eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_PURGE dependencies on CE_BANK_ACCOUNTS

Line 65: p_BANK_ACCOUNT_ID ce_bank_accounts.BANK_ACCOUNT_ID%TYPE,

61: | HISTORY |
62: | 29-Dec-2010 Created Rtumati |
63: --------------------------------------------------------------------- */
64: PROCEDURE set_parameters(
65: p_BANK_ACCOUNT_ID ce_bank_accounts.BANK_ACCOUNT_ID%TYPE,
66: p_BANK_BRANCH_ID ce_bank_accounts.BANK_branch_ID%TYPE,
67: p_STATEMENT_DATE_FROM ce_statement_headers.statement_date%TYPE,
68: p_STATEMENT_DATE_TO ce_statement_headers.statement_date%TYPE,
69: p_Bank_Name ce_bank_branches_v.bank_name%TYPE,

Line 66: p_BANK_BRANCH_ID ce_bank_accounts.BANK_branch_ID%TYPE,

62: | 29-Dec-2010 Created Rtumati |
63: --------------------------------------------------------------------- */
64: PROCEDURE set_parameters(
65: p_BANK_ACCOUNT_ID ce_bank_accounts.BANK_ACCOUNT_ID%TYPE,
66: p_BANK_BRANCH_ID ce_bank_accounts.BANK_branch_ID%TYPE,
67: p_STATEMENT_DATE_FROM ce_statement_headers.statement_date%TYPE,
68: p_STATEMENT_DATE_TO ce_statement_headers.statement_date%TYPE,
69: p_Bank_Name ce_bank_branches_v.bank_name%TYPE,
70: p_Bank_Branch_Name ce_bank_branches_v.bank_branch_name%TYPE,

Line 71: p_Bank_Account_Name ce_bank_accounts.Bank_Account_Name%TYPE,

67: p_STATEMENT_DATE_FROM ce_statement_headers.statement_date%TYPE,
68: p_STATEMENT_DATE_TO ce_statement_headers.statement_date%TYPE,
69: p_Bank_Name ce_bank_branches_v.bank_name%TYPE,
70: p_Bank_Branch_Name ce_bank_branches_v.bank_branch_name%TYPE,
71: p_Bank_Account_Name ce_bank_accounts.Bank_Account_Name%TYPE,
72: p_Currency_Code ce_bank_accounts.Currency_Code%TYPE,
73: p_Bank_Account_Num ce_bank_accounts.Bank_Account_Num%TYPE,
74: p_Archive_Purge_Option VARCHAR2,
75: p_Delete_Or_Append_Action VARCHAR2,

Line 72: p_Currency_Code ce_bank_accounts.Currency_Code%TYPE,

68: p_STATEMENT_DATE_TO ce_statement_headers.statement_date%TYPE,
69: p_Bank_Name ce_bank_branches_v.bank_name%TYPE,
70: p_Bank_Branch_Name ce_bank_branches_v.bank_branch_name%TYPE,
71: p_Bank_Account_Name ce_bank_accounts.Bank_Account_Name%TYPE,
72: p_Currency_Code ce_bank_accounts.Currency_Code%TYPE,
73: p_Bank_Account_Num ce_bank_accounts.Bank_Account_Num%TYPE,
74: p_Archive_Purge_Option VARCHAR2,
75: p_Delete_Or_Append_Action VARCHAR2,
76: p_Objects VARCHAR2,

Line 73: p_Bank_Account_Num ce_bank_accounts.Bank_Account_Num%TYPE,

69: p_Bank_Name ce_bank_branches_v.bank_name%TYPE,
70: p_Bank_Branch_Name ce_bank_branches_v.bank_branch_name%TYPE,
71: p_Bank_Account_Name ce_bank_accounts.Bank_Account_Name%TYPE,
72: p_Currency_Code ce_bank_accounts.Currency_Code%TYPE,
73: p_Bank_Account_Num ce_bank_accounts.Bank_Account_Num%TYPE,
74: p_Archive_Purge_Option VARCHAR2,
75: p_Delete_Or_Append_Action VARCHAR2,
76: p_Objects VARCHAR2,
77: p_Statement_type VARCHAR2,

Line 781: FROM ce_bank_accounts aba --CE_BANK_ACCTS_GT_V aba

777: where sh.statement_header_id = sl.statement_header_id
778: and sl.statement_line_id= sr.statement_line_id
779: and sh.statement_header_id = csh.statement_header_id
780: and sh.bank_account_id IN (SELECT aba.bank_account_id
781: FROM ce_bank_accounts aba --CE_BANK_ACCTS_GT_V aba
782: WHERE aba.bank_branch_id = CE_PURGE.G_BANK_BRANCH_ID)
783: AND sh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, sh.statement_date)
784: AND sh.statement_date <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, sh.statement_date)
785: and sr.CURRENT_RECORD_FLAG = 'Y'

Line 1519: FROM ce_BANK_ACCOUNTS aba

1515: LAST_UPDATED_BY,
1516: LAST_UPDATE_DATE
1517: FROM ce_intra_stmt_headers csh
1518: WHERE csh.bank_account_id IN (SELECT aba.bank_account_id
1519: FROM ce_BANK_ACCOUNTS aba
1520: WHERE aba.bank_branch_id = G_BANK_BRANCH_ID)
1521: AND trunc(csh.statement_date) >= NVL(G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
1522: AND trunc(csh.statement_date) <= NVL(G_STATEMENT_DATE_TO, trunc(csh.statement_date));
1523: G_Archive_Stat_Headers2 := SQL%ROWCOUNT;

Line 1749: -- 2) Sub-query (not exists) should select from ce_bank_accounts table,

1745: -- must have access to all the reconciled trx's
1746: -- org (ce_statement_reconcils_all.org_id and ce_statement_reconcils_all.legal_entity_id)
1747: -- This is to ensure that there are no orphan trx data in the system
1748: -- 1) Main query - should query from security view (ce_bank_accts_gt_v)
1749: -- 2) Sub-query (not exists) should select from ce_bank_accounts table,
1750: -- This query is to select all stmts that the users do not have access to.
1751: -- If stmts exists in this subquery then the stmt should not be deleted.
1752: -- This is to ensure that there are no orphan trx data in the system
1753:

Line 1775: FROM ce_bank_accounts ba --ce_bank_accts_gt_v ba

1771: and sh.statement_header_id= csh.statement_header_id
1772: and sh.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,bank_account_id)
1773: AND sh.bank_account_id IN
1774: (SELECT bank_account_id
1775: FROM ce_bank_accounts ba --ce_bank_accts_gt_v ba
1776: WHERE ba.bank_branch_id = NVL(CE_PURGE.G_BANK_BRANCH_ID,ba.bank_branch_id) )
1777: AND trunc(sh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(sh.statement_date))
1778: AND trunc(sh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(sh.statement_date))
1779: and sr.CURRENT_RECORD_FLAG = 'Y'

Line 2108: FROM ce_bank_accounts aba --CE_BANK_ACCTS_GT_V aba

2104: WHERE ( csh.bank_account_id = Nvl(CE_PURGE.G_BANK_ACCOUNT_ID,-1)
2105: OR
2106: (CE_PURGE.G_BANK_ACCOUNT_ID IS NULL
2107: AND (csh.bank_account_id in (SELECT aba.bank_account_id
2108: FROM ce_bank_accounts aba --CE_BANK_ACCTS_GT_V aba
2109: WHERE aba.bank_branch_id = Nvl(CE_PURGE.G_BANK_branch_ID,aba.bank_branch_id)))))
2110: AND csh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, csh.statement_date)
2111: AND csh.statement_date <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, csh.statement_date)
2112: AND not exists

Line 2122: FROM ce_bank_accounts aba --CE_BANK_ACCTS_GT_V aba

2118: and ( csh.bank_account_id = Nvl(CE_PURGE.G_BANK_ACCOUNT_ID,-1)
2119: OR
2120: (CE_PURGE.G_BANK_ACCOUNT_ID IS NULL
2121: AND (sh.bank_account_id in (SELECT aba.bank_account_id
2122: FROM ce_bank_accounts aba --CE_BANK_ACCTS_GT_V aba
2123: WHERE aba.bank_branch_id = Nvl(CE_PURGE.G_BANK_branch_ID,aba.bank_branch_id)))))
2124: AND sh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, sh.statement_date)
2125: AND sh.statement_date <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, sh.statement_date)
2126: and sr.CURRENT_RECORD_FLAG = 'Y'

Line 2135: l_bank_account_name ce_bank_accounts.Bank_Account_Name%TYPE;

2131: where lbg.organization_id = sr.org_id or
2132: sr.legal_entity_id = lbg.organization_id ) )
2133: FOR update;
2134:
2135: l_bank_account_name ce_bank_accounts.Bank_Account_Name%TYPE;
2136: l_bank_account_num CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;
2137: l_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE;
2138: l_No_data_flag VARCHAR2(1):='Y';
2139:

Line 2136: l_bank_account_num CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;

2132: sr.legal_entity_id = lbg.organization_id ) )
2133: FOR update;
2134:
2135: l_bank_account_name ce_bank_accounts.Bank_Account_Name%TYPE;
2136: l_bank_account_num CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;
2137: l_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE;
2138: l_No_data_flag VARCHAR2(1):='Y';
2139:
2140: BEGIN

Line 2137: l_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE;

2133: FOR update;
2134:
2135: l_bank_account_name ce_bank_accounts.Bank_Account_Name%TYPE;
2136: l_bank_account_num CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;
2137: l_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE;
2138: l_No_data_flag VARCHAR2(1):='Y';
2139:
2140: BEGIN
2141:

Line 2158: FROM ce_bank_accounts

2154: l_No_data_flag :='N';
2155:
2156: SELECT Bank_Account_Name,BANK_ACCOUNT_NUM, currency_code
2157: INTO l_bank_account_name, l_bank_account_num , l_currency_code
2158: FROM ce_bank_accounts
2159: WHERE bank_account_id = r_stmt.bank_account_id;
2160:
2161: INSERT INTO ce_statement_headers (
2162: STATEMENT_COMPLETE_FLAG,

Line 2538: FROM ce_BANK_ACCOUNTS aba

2534: WHERE ( csh.bank_account_id = Nvl(CE_PURGE.G_BANK_ACCOUNT_ID,-1)
2535: OR
2536: (CE_PURGE.G_BANK_ACCOUNT_ID IS NULL
2537: AND csh.bank_account_id IN (SELECT aba.bank_account_id
2538: FROM ce_BANK_ACCOUNTS aba
2539: WHERE aba.bank_branch_id = Nvl(CE_PURGE.G_BANK_BRANCH_ID,aba.bank_branch_id))))
2540: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
2541: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))
2542: FOR update;

Line 2544: l_bank_account_name ce_bank_accounts.Bank_Account_Name%TYPE;

2540: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
2541: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))
2542: FOR update;
2543:
2544: l_bank_account_name ce_bank_accounts.Bank_Account_Name%TYPE;
2545: l_bank_account_num CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;
2546: l_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE;
2547: l_No_data_flag VARCHAR2(1):='Y';
2548: BEGIN

Line 2545: l_bank_account_num CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;

2541: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))
2542: FOR update;
2543:
2544: l_bank_account_name ce_bank_accounts.Bank_Account_Name%TYPE;
2545: l_bank_account_num CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;
2546: l_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE;
2547: l_No_data_flag VARCHAR2(1):='Y';
2548: BEGIN
2549:

Line 2546: l_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE;

2542: FOR update;
2543:
2544: l_bank_account_name ce_bank_accounts.Bank_Account_Name%TYPE;
2545: l_bank_account_num CE_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;
2546: l_currency_code CE_BANK_ACCOUNTS.currency_code%TYPE;
2547: l_No_data_flag VARCHAR2(1):='Y';
2548: BEGIN
2549:
2550: IF l_DEBUG in ('Y', 'C') THEN

Line 2565: FROM ce_bank_accounts

2561: l_No_data_flag := 'N';
2562:
2563: SELECT Bank_Account_Name,BANK_ACCOUNT_NUM, currency_code
2564: INTO l_bank_account_name, l_bank_account_num , l_currency_code
2565: FROM ce_bank_accounts
2566: WHERE bank_account_id = r_intraStmt.bank_account_id;
2567:
2568: INSERT INTO ce_intra_stmt_headers (
2569: STATEMENT_COMPLETE_FLAG,

Line 2911: FROM ce_bank_accounts ce

2907: ELSE
2908:
2909: SELECT Bank_Account_Name
2910: INTO l_bank_account_name
2911: FROM ce_bank_accounts ce
2912: WHERE ce.bank_account_num = r_interface.bank_account_num
2913: AND ce.bank_branch_id=(SELECT Branch_party_id
2914: FROM ce_bank_Branches_v
2915: WHERE bank_branch_name = Nvl(r_interface.BANK_BRANCH_NAME,G_BANK_BRANCH_NAME))

Line 3204: p_BANK_BRANCH_ID IN ce_bank_accounts.BANK_branch_ID%TYPE,

3200: retcode OUT NOCOPY NUMBER,
3201: p_Objects IN VARCHAR2,
3202: p_Statement_type IN VARCHAR2,
3203: p_hdr_int_status IN VARCHAR2,
3204: p_BANK_BRANCH_ID IN ce_bank_accounts.BANK_branch_ID%TYPE,
3205: p_BANK_ACCOUNT_ID IN ce_bank_accounts.BANK_ACCOUNT_ID%TYPE,
3206: p_STATEMENT_DATE_FROM IN VARCHAR2,-- ce_statement_headers.statement_date%TYPE,
3207: p_STATEMENT_DATE_TO IN VARCHAR2, --ce_statement_headers.statement_date%TYPE,
3208: X_sql_trace IN VARCHAR2 ,

Line 3205: p_BANK_ACCOUNT_ID IN ce_bank_accounts.BANK_ACCOUNT_ID%TYPE,

3201: p_Objects IN VARCHAR2,
3202: p_Statement_type IN VARCHAR2,
3203: p_hdr_int_status IN VARCHAR2,
3204: p_BANK_BRANCH_ID IN ce_bank_accounts.BANK_branch_ID%TYPE,
3205: p_BANK_ACCOUNT_ID IN ce_bank_accounts.BANK_ACCOUNT_ID%TYPE,
3206: p_STATEMENT_DATE_FROM IN VARCHAR2,-- ce_statement_headers.statement_date%TYPE,
3207: p_STATEMENT_DATE_TO IN VARCHAR2, --ce_statement_headers.statement_date%TYPE,
3208: X_sql_trace IN VARCHAR2 ,
3209: X_debug_path IN VARCHAR2