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_STATEMENT_HEADERS

Line 67: p_STATEMENT_DATE_FROM ce_statement_headers.statement_date%TYPE,

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,
71: p_Bank_Account_Name ce_bank_accounts.Bank_Account_Name%TYPE,

Line 68: p_STATEMENT_DATE_TO ce_statement_headers.statement_date%TYPE,

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,
71: p_Bank_Account_Name ce_bank_accounts.Bank_Account_Name%TYPE,
72: p_Currency_Code ce_bank_accounts.Currency_Code%TYPE,

Line 224: ce_statement_headers csh

220: WHERE car.statement_line_id IN
221: (SELECT cl.statement_line_id FROM ce_arch_lines cl WHERE
222: cl.statement_header_id IN (SELECT cah.statement_header_id
223: FROM ce_arch_headers cah ,
224: ce_statement_headers csh
225: WHERE cah.bank_account_id = csh.bank_account_id
226: AND csh.statement_number = cah.statement_number
227: AND csh.org_id = cah.org_id
228: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))

Line 242: ce_statement_headers csh

238:
239: DELETE FROM CE_ARCH_RECON_ERRORS cre
240: WHERE cre.statement_line_id IN (SELECT cah.statement_header_id
241: FROM ce_arch_headers cah ,
242: ce_statement_headers csh
243: WHERE cah.bank_account_id = csh.bank_account_id
244: AND csh.statement_number = cah.statement_number
245: AND csh.org_id = cah.org_id
246: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))

Line 260: ce_statement_headers csh

256:
257: DELETE FROM CE_ARCH_LINES
258: WHERE statement_header_id IN (SELECT cah.statement_header_id
259: FROM ce_arch_headers cah ,
260: ce_statement_headers csh
261: WHERE cah.bank_account_id = csh.bank_account_id
262: AND csh.statement_number = cah.statement_number
263: AND csh.org_id = cah.org_id
264: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))

Line 278: ce_statement_headers csh

274:
275: DELETE FROM CE_ARCH_HEADERS
276: WHERE statement_header_id IN (SELECT cah.statement_header_id
277: FROM ce_arch_headers cah ,
278: ce_statement_headers csh
279: WHERE cah.bank_account_id = csh.bank_account_id
280: AND csh.statement_number = cah.statement_number
281: AND csh.org_id = cah.org_id
282: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))

Line 300: FROM ce_statement_headers_int csh

296:
297: DELETE FROM CE_ARCH_INTERFACE_LINES cal
298: WHERE cal.statement_number ||'-'|| cal.bank_account_num IN
299: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
300: FROM ce_statement_headers_int csh
301: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name
302: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
303: WHERE bb.branch_party_id = ba.bank_branch_id
304: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)

Line 322: FROM ce_statement_headers_int csh

318:
319: DELETE FROM CE_ARCH_INTERFACE_HEADERS cah
320: WHERE cah.statement_number ||'-'|| cah.bank_account_num IN
321: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
322: FROM ce_statement_headers_int csh
323: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN
324: (SELECT bb.bank_branch_name
325: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
326: WHERE bb.branch_party_id = ba.bank_branch_id

Line 395: FROM ce_statement_headers_int csh

391:
392: DELETE FROM CE_ARCH_INTERFACE_LINES cal
393: WHERE cal.statement_number ||'-'|| cal.bank_account_num IN
394: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
395: FROM ce_statement_headers_int csh
396: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (
397: SELECT bb.bank_branch_name
398: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
399: WHERE bb.branch_party_id = ba.bank_branch_id

Line 420: FROM ce_statement_headers_int csh

416:
417: DELETE FROM CE_ARCH_INTERFACE_HEADERS cah
418: WHERE cah.statement_number ||'-'|| cah.bank_account_num IN
419: (SELECT csh.statement_number ||'-'|| csh.bank_account_num
420: FROM ce_statement_headers_int csh
421: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN
422: (SELECT bb.bank_branch_name
423: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
424: WHERE bb.branch_party_id = ba.bank_branch_id

Line 642: FROM ce_statement_headers csh

638: CREATED_BY,
639: CREATION_DATE,
640: LAST_UPDATED_BY,
641: LAST_UPDATE_DATE
642: FROM ce_statement_headers csh
643: WHERE csh.bank_account_id = CE_PURGE.G_BANK_ACCOUNT_ID
644: AND csh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, csh.statement_date)
645: AND csh.statement_date <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, csh.statement_date)
646: AND not exists

Line 648: from ce_statement_headers sh, ce_statement_lines sl , ce_statement_reconcils_all sr

644: AND csh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, csh.statement_date)
645: AND csh.statement_date <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, csh.statement_date)
646: AND not exists
647: (select 1 -- find all stmts that are not in ce_security_profiles_gt (cannot delete these stmts)
648: from ce_statement_headers sh, ce_statement_lines sl , ce_statement_reconcils_all sr
649: where sh.statement_header_id = sl.statement_header_id
650: and sl.statement_line_id= sr.statement_line_id
651: and sh.statement_header_id= csh.statement_header_id
652: and sh.bank_account_id = CE_PURGE.G_BANK_ACCOUNT_ID

Line 768: FROM ce_statement_headers csh

764: CREATED_BY,
765: CREATION_DATE,
766: LAST_UPDATED_BY,
767: LAST_UPDATE_DATE
768: FROM ce_statement_headers csh
769: WHERE csh.bank_account_id IN (SELECT aba.bank_account_id
770: FROM CE_BANK_ACCTS_GT_V aba
771: WHERE aba.bank_branch_id = CE_PURGE.G_BANK_BRANCH_ID)
772: AND csh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, csh.statement_date)

Line 776: from ce_statement_headers sh, ce_statement_lines sl , ce_statement_reconcils_all sr

772: AND csh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, csh.statement_date)
773: AND csh.statement_date <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, csh.statement_date)
774: AND not exists
775: (select 1 -- find all stmts that are not in ce_security_profiles_gt (cannot delete these stmts)
776: from ce_statement_headers sh, ce_statement_lines sl , ce_statement_reconcils_all sr
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

Line 893: FROM ce_statement_headers csh

889: CREATED_BY,
890: CREATION_DATE,
891: LAST_UPDATED_BY,
892: LAST_UPDATE_DATE
893: FROM ce_statement_headers csh
894: WHERE csh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, csh.statement_date)
895: AND csh.statement_date <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, csh.statement_date)
896: AND not exists
897: (select 1

Line 898: from ce_statement_headers sh, ce_statement_lines sl , ce_statement_reconcils_all sr

894: WHERE csh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, csh.statement_date)
895: AND csh.statement_date <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, csh.statement_date)
896: AND not exists
897: (select 1
898: from ce_statement_headers sh, ce_statement_lines sl , ce_statement_reconcils_all sr
899: where sh.statement_header_id = sl.statement_header_id
900: and sl.statement_line_id= sr.statement_line_id
901: and sh.statement_header_id= csh.statement_header_id
902: and sh.statement_date >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, sh.statement_date)

Line 1188: FROM ce_statement_headers_int csh

1184: LAST_UPDATED_BY,
1185: LAST_UPDATE_DATE,
1186: INTRA_DAY_FLAG
1187: --ORG_ID
1188: FROM ce_statement_headers_int csh
1189: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name
1190: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
1191: WHERE bb.branch_party_id = ba.bank_branch_id
1192: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)

Line 1289: FROM ce_statement_headers_int csh

1285: USER_EXCHANGE_RATE_TYPE
1286: FROM ce_statement_lines_interface csl
1287: WHERE csl.statement_number ||'-'|| csl.bank_account_num IN (
1288: SELECT csh.statement_number ||'-'|| csh.bank_account_num
1289: FROM ce_statement_headers_int csh
1290: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name
1291: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
1292: WHERE bb.branch_party_id = ba.bank_branch_id
1293: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)

Line 1757: FROM ce_statement_headers csh

1753:
1754: -- Cursor to purge the statement Headers
1755: CURSOR C_PURGE_HEADERS IS
1756: SELECT csh.statement_header_id
1757: FROM ce_statement_headers csh
1758: WHERE csh.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,bank_account_id)
1759: AND csh.bank_account_id IN
1760: (SELECT bank_account_id
1761: FROM ce_bank_accts_gt_v ba

Line 1767: from ce_statement_headers sh, ce_statement_lines sl , ce_statement_reconcils_all sr

1763: AND trunc(csh.statement_date) >= NVL(CE_PURGE.G_STATEMENT_DATE_FROM, trunc(csh.statement_date))
1764: AND trunc(csh.statement_date) <= NVL(CE_PURGE.G_STATEMENT_DATE_TO, trunc(csh.statement_date))
1765: AND not exists
1766: (select 1 -- find all stmts that are not in ce_security_profiles_gt (cannot delete these stmts)
1767: from ce_statement_headers sh, ce_statement_lines sl , ce_statement_reconcils_all sr
1768: where sh.statement_header_id = sl.statement_header_id
1769: and sl.statement_line_id= sr.statement_line_id
1770: -- AND sl.status = Decode(G_Only_Unrec,'Y','RECONCILED',sl.status)
1771: and sh.statement_header_id= csh.statement_header_id

Line 1841: -- Archives the Ce statement Headers lines along with reconcile history and reconcile errors

1837:
1838: IF (CE_PURGE.G_STATEMENT_TYPE IN ('BOTH','PREVIOUS')) THEN
1839: IF( CE_PURGE.G_OBJECTS IN ('BOTH', 'STATEMENT') ) THEN
1840: IF( CE_PURGE.G_Archive_Purge_Option IN ('BOTH')) THEN
1841: -- Archives the Ce statement Headers lines along with reconcile history and reconcile errors
1842: arch_ce_statements;
1843: END IF;
1844: --
1845: -- bug# 924584

Line 1852: DELETE FROM ce_statement_headers

1848: FETCH C_PURGE_HEADERS INTO X_header_id;
1849: LOOP
1850: EXIT WHEN c_purge_headers%NOTFOUND;
1851:
1852: DELETE FROM ce_statement_headers
1853: WHERE statement_header_id = X_header_id;
1854: purge_headers := purge_headers + SQL%ROWCOUNT;
1855:
1856: OPEN C_PURGE_LINES;

Line 1903: FROM ce_statement_headers_int csh

1899:
1900: DELETE FROM ce_statement_lines_interface csl
1901: WHERE csl.statement_number ||'-'|| csl.bank_account_num IN
1902: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
1903: FROM ce_statement_headers_int csh
1904: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name
1905: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
1906: WHERE bb.branch_party_id = ba.bank_branch_id
1907: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)

Line 1920: DELETE FROM ce_statement_headers_int csh

1916: AND nvl(csh.intra_day_flag, 'N') = 'N');
1917:
1918: CE_PURGE.G_Purge_Inf_Lines := SQL%ROWCOUNT;
1919:
1920: DELETE FROM ce_statement_headers_int csh
1921: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN
1922: (SELECT bb.bank_branch_name
1923: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
1924: WHERE bb.branch_party_id = ba.bank_branch_id

Line 1998: FROM ce_statement_headers_int csh

1994:
1995: DELETE FROM ce_statement_lines_interface csl
1996: WHERE csl.statement_number ||'-'|| csl.bank_account_num IN
1997: ( SELECT csh.statement_number ||'-'|| csh.bank_account_num
1998: FROM ce_statement_headers_int csh
1999: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN (SELECT bb.bank_branch_name
2000: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
2001: WHERE bb.branch_party_id = ba.bank_branch_id
2002: AND ba.bank_account_id = NVL(CE_PURGE.G_BANK_ACCOUNT_ID,ba.bank_account_id)

Line 2016: DELETE FROM ce_statement_headers_int csh

2012: AND csh.intra_day_flag = 'Y');
2013:
2014: CE_PURGE.G_Purge_Inf_Lines2 := SQL%ROWCOUNT;
2015:
2016: DELETE FROM ce_statement_headers_int csh
2017: WHERE NVL(csh.bank_branch_name,CE_PURGE.G_BANK_BRANCH_NAME) IN
2018: (SELECT bb.bank_branch_name
2019: FROM ce_bank_branches_v bb, ce_bank_accts_gt_v ba
2020: WHERE bb.branch_party_id = ba.bank_branch_id

Line 2161: INSERT INTO ce_statement_headers (

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,
2163: --ORG_ID,
2164: DOC_SEQUENCE_ID,
2165: DOC_SEQUENCE_VALUE,

Line 2931: INSERT INTO ce_statement_headers_int

2927: l_bank_account_name:= fnd_message.get;
2928: END;
2929:
2930:
2931: INSERT INTO ce_statement_headers_int
2932: (STATEMENT_NUMBER,
2933: BANK_ACCOUNT_NUM,
2934: STATEMENT_DATE,
2935: BANK_NAME,

Line 3206: p_STATEMENT_DATE_FROM IN VARCHAR2,-- ce_statement_headers.statement_date%TYPE,

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
3210: ) IS

Line 3207: p_STATEMENT_DATE_TO IN VARCHAR2, --ce_statement_headers.statement_date%TYPE,

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
3210: ) IS
3211: error_found BOOLEAN:= FALSE;