[Home] [Help]
PACKAGE: APPS.CN_PURGE_TABLES_PVT
Source
1 PACKAGE CN_PURGE_TABLES_PVT AUTHID CURRENT_USER AS
2 /* $Header: CNVTPRGS.pls 120.0.12010000.3 2010/06/17 05:01:44 sseshaiy noship $*/
3
4 cn_payment_api_all_id CONSTANT NUMBER := 0;
5 cn_posting_details_all_id CONSTANT NUMBER := 1;
6 cn_payment_transactions_all_id CONSTANT NUMBER := 2;
7 cn_commission_lines_all_id CONSTANT NUMBER := 3;
8 cn_commission_headers_all_id CONSTANT NUMBER := 4;
9 cn_trx_sales_lines_all_id CONSTANT NUMBER := 5;
10 cn_trx_lines_all_id CONSTANT NUMBER := 6;
11 cn_trx_all_id CONSTANT NUMBER := 7;
12 cn_not_trx_all_id CONSTANT NUMBER := 8;
13 cn_invoice_changes_all_id CONSTANT NUMBER := 9;
14 cn_imp_headers_id CONSTANT NUMBER := 10;
15 cn_imp_lines_id CONSTANT NUMBER := 11;
16 cn_comm_lines_api_all_id CONSTANT NUMBER := 12;
17 cn_srp_payee_assigns_all_id CONSTANT NUMBER := 13;
18 cn_srp_quota_assigns_all_id CONSTANT NUMBER := 14;
19 cn_srp_rate_assigns_all_id CONSTANT NUMBER := 15;
20 cn_srp_rule_uplifts_all_id CONSTANT NUMBER := 16;
21 cn_srp_quota_rules_all_id CONSTANT NUMBER := 17;
22 cn_srp_plan_assigns_all_id CONSTANT NUMBER := 18;
23 cn_srp_period_quotas_ext_all_i CONSTANT NUMBER := 19;
24 cn_srp_per_quota_rc_all_id CONSTANT NUMBER := 20;
25 cn_srp_period_quotas_all_id CONSTANT NUMBER := 21;
26 cn_pay_approval_flow_all_id CONSTANT NUMBER := 22;
27 cn_worksheet_qg_dtls_all_id CONSTANT NUMBER := 23;
28 cn_payment_worksheets_all_id CONSTANT NUMBER := 24;
29 cn_ledger_journal_entries_alli CONSTANT NUMBER := 25;
30 cn_posting_details_sum_all_id CONSTANT NUMBER := 26;
31 cn_worksheet_bonuses_all_id CONSTANT NUMBER := 27;
32 cn_payruns_all_id CONSTANT NUMBER := 29;
33 cn_srp_periods_all_id CONSTANT NUMBER := 30;
34 cn_process_audits_all_id CONSTANT NUMBER := 31;
35 cn_process_audit_lines_all_id CONSTANT NUMBER := 32;
36 cn_process_batches_all_id CONSTANT NUMBER := 33;
37 cn_srp_intel_periods_all_id CONSTANT NUMBER := 34;
38
39 type imp_header
40 IS
41 record
42 (
43 imp_header_id cn_imp_lines.IMP_HEADER_ID%type);
44
45 type l_imp_header_id_tbl_type
46 IS
47 TABLE OF cn_imp_lines.imp_header_id%type INDEX BY binary_integer;
48
49 -- API name : archive_purge_cn_tables
50 -- Type : public.
51 -- Pre-reqs :
52 PROCEDURE archive_purge_cn_tables
53 (
54 errbuf OUT NOCOPY VARCHAR2,
55 retcode OUT NOCOPY VARCHAR2,
56 p_run_mode IN VARCHAR2,
57 p_start_period_id IN NUMBER,
58 p_end_period_id IN NUMBER,
59 p_no_of_workers IN NUMBER,
60 p_org_id IN NUMBER,
61 p_table_space IN VARCHAR2,
62 p_worker_id IN NUMBER,
63 p_batch_size IN NUMBER,
64 p_request_id IN NUMBER
65 );
66
67 PROCEDURE audit_purge_cn_tables
71 p_end_period_id IN NUMBER,
68 (
69 p_run_mode IN VARCHAR2,
70 p_start_period_id IN NUMBER,
72 p_org_id IN NUMBER,
73 p_worker_id IN NUMBER,
74 p_no_of_workers IN NUMBER,
75 p_batch_size IN NUMBER,
76 x_msg_count OUT nocopy NUMBER,
77 x_msg_data OUT nocopy VARCHAR2,
78 x_return_status OUT nocopy VARCHAR2
79 );
80
81 END CN_PURGE_TABLES_PVT;