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.CSI_TXN_HISTORY_PURGE_PVT dependencies on CSI_TXN_HISTORY_PURGE_PVT

Line 1: PACKAGE BODY CSI_TXN_HISTORY_PURGE_PVT AS

1: PACKAGE BODY CSI_TXN_HISTORY_PURGE_PVT AS
2: /* $Header: csivthpb.pls 120.2 2005/06/17 17:38:20 appldev $ */
3:
4: -- --------------------------------------------------------
5: -- Define global variables

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_TXN_HISTORY_PURGE_PVT';

4: -- --------------------------------------------------------
5: -- Define global variables
6: -- --------------------------------------------------------
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_TXN_HISTORY_PURGE_PVT';
9: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csivthpb.pls';
10: --
11: --
12: -- Procedure to debug the discrepancies

Line 114: /* csi_txn_history_purge_pvt.Record_count(From_trans => From_trans,

110: --
111: -- srramakr Bug 4366231. The following routine joins each entity history table with CSI_TRANSACTIONS
112: -- to get the count of records purged and archieved. This causes lot of performance issue. Giving such
113: -- count is unnecessary. The user can always check against the archive table. Hence commenting it.
114: /* csi_txn_history_purge_pvt.Record_count(From_trans => From_trans,
115: To_trans => To_trans,
116: Purge_to_date => purge_to_date,
117: Recs_count => l_recs_archived ); */
118: --

Line 474: l_inst_hist_rec_tab csi_txn_history_purge_pvt.instance_history_rec_tab;

470: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
471: And csh.transaction_id = csit.transaction_id;
472:
473: l_inst_hist_csr inst_hist_csr%RowType;
474: l_inst_hist_rec_tab csi_txn_history_purge_pvt.instance_history_rec_tab;
475:
476:
477: Begin
478: --

Line 1416: l_pty_hist_rec_tab csi_txn_history_purge_pvt.party_history_rec_tab;

1412: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
1413: And csh.transaction_id = csit.transaction_id;
1414:
1415: l_pty_hist_csr pty_hist_csr%RowType;
1416: l_pty_hist_rec_tab csi_txn_history_purge_pvt.party_history_rec_tab;
1417:
1418:
1419: Begin
1420: --

Line 1859: l_acct_hist_rec_tab csi_txn_history_purge_pvt.account_history_rec_tab;

1855: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
1856: And csh.transaction_id = csit.transaction_id;
1857:
1858: l_acct_hist_csr acct_hist_csr%RowType;
1859: l_acct_hist_rec_tab csi_txn_history_purge_pvt.account_history_rec_tab;
1860:
1861:
1862: Begin
1863: --

Line 2286: l_org_units_hist_rec_tab csi_txn_history_purge_pvt.org_units_history_rec_tab;

2282: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
2283: And csh.transaction_id = csit.transaction_id;
2284:
2285: l_org_units_hist_csr org_units_hist_csr%ROWTYPE;
2286: l_org_units_hist_rec_tab csi_txn_history_purge_pvt.org_units_history_rec_tab;
2287:
2288:
2289: Begin
2290: --

Line 2689: l_ext_attrib_hist_rec_tab csi_txn_history_purge_pvt.ext_attrib_history_rec_tab;

2685: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
2686: And csh.transaction_id = csit.transaction_id;
2687:
2688: l_ext_attrib_hist_csr ext_attrib_hist_csr%ROWTYPE;
2689: l_ext_attrib_hist_rec_tab csi_txn_history_purge_pvt.ext_attrib_history_rec_tab;
2690:
2691:
2692: Begin
2693: --

Line 3085: l_pri_attribs_hist_rec_tab csi_txn_history_purge_pvt.pricing_attribs_hist_rec_tab;

3081: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
3082: And csh.transaction_id = csit.transaction_id;
3083:
3084: l_pri_attribs_hist_csr pri_attribs_hist_csr%ROWTYPE;
3085: l_pri_attribs_hist_rec_tab csi_txn_history_purge_pvt.pricing_attribs_hist_rec_tab;
3086:
3087:
3088: Begin
3089: --

Line 4280: l_ins_asset_hist_rec_tab csi_txn_history_purge_pvt.ins_asset_history_rec_tab;

4276: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
4277: And csh.transaction_id = csit.transaction_id;
4278:
4279: l_ins_asset_hist_csr ins_asset_hist_csr%ROWTYPE;
4280: l_ins_asset_hist_rec_tab csi_txn_history_purge_pvt.ins_asset_history_rec_tab;
4281:
4282:
4283: Begin
4284: --

Line 4583: l_ver_label_hist_rec_tab csi_txn_history_purge_pvt.ver_label_history_rec_tab;

4579: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
4580: And csh.transaction_id = csit.transaction_id;
4581:
4582: l_ver_label_hist_csr ver_label_hist_csr%ROWTYPE;
4583: l_ver_label_hist_rec_tab csi_txn_history_purge_pvt.ver_label_history_rec_tab;
4584:
4585:
4586: Begin
4587: --

Line 4995: l_rel_hist_rec_tab csi_txn_history_purge_pvt.relationship_history_rec_tab;

4991: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
4992: And csh.transaction_id = csit.transaction_id;
4993:
4994: l_rel_hist_csr rel_hist_csr%ROWTYPE;
4995: l_rel_hist_rec_tab csi_txn_history_purge_pvt.relationship_history_rec_tab;
4996:
4997:
4998: Begin
4999: --

Line 5406: l_sys_hist_rec_tab csi_txn_history_purge_pvt.system_history_rec_tab;

5402: And csit.creation_date < to_date(purge_to_date, 'YYYY/MM/DD HH24:MI:SS')
5403: And csh.transaction_id = csit.transaction_id;
5404:
5405: l_sys_hist_csr sys_hist_csr%ROWTYPE;
5406: l_sys_hist_rec_tab csi_txn_history_purge_pvt.system_history_rec_tab;
5407:
5408:
5409: Begin
5410: --

Line 6057: END CSI_TXN_HISTORY_PURGE_PVT;

6053: Recs_Count := l_temp+l_temp1+l_temp2+l_temp3+l_temp4+l_temp5+l_temp6+l_temp7+l_temp8+l_temp9;
6054:
6055: End;
6056:
6057: END CSI_TXN_HISTORY_PURGE_PVT;