[Home] [Help]
PACKAGE: APPS.CE_PURGE
Source
1 PACKAGE ce_purge AUTHID CURRENT_USER as
2 /* $Header: cepurestrs.pls 120.1 2011/02/24 10:09:34 rtumati noship $ */
3 --
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;
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);
21 G_HDR_INT_STATUS VARCHAR2(30);
22 G_Only_Unrec VARCHAR2(30); /* 10400780*/
23 G_status VARCHAR2(30);
24
25 G_Purge_Inf_Headers NUMBER := 0;
26 G_Purge_Inf_Lines NUMBER := 0;
27 G_Purge_Stat_Lines NUMBER := 0;
28 G_Purge_Stat_Headers NUMBER := 0;
29 G_Purge_Stat_Rec NUMBER := 0;
30 G_Purge_Stat_Errors NUMBER := 0;
31 G_Purge_Inf_Headers2 NUMBER := 0;
32 G_Purge_Inf_Lines2 NUMBER := 0;
33 G_Purge_Stat_Lines2 NUMBER := 0;
34 G_Purge_Stat_Headers2 NUMBER := 0;
35 G_Archive_Inf_Headers NUMBER := 0;
36 G_Archive_Inf_Lines NUMBER := 0;
37 G_Archive_Stat_Headers NUMBER := 0;
38 G_Archive_Stat_Lines NUMBER := 0;
39 G_Archive_Stat_Errors NUMBER := 0;
40 G_Archive_Stat_Rec NUMBER := 0;
41 G_Archive_Inf_Lines2 NUMBER := 0;
42 G_Archive_Inf_Headers2 NUMBER := 0;
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,
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,
60 p_hdr_int_status VARCHAR2,
61 p_Only_Unrec VARCHAR2); /* 10400780*/
62
63
64 PROCEDURE get_arch_purge_counts(
65 P_Purge_Inf_Headers OUT NOCOPY NUMBER,
66 P_Purge_Inf_Lines OUT NOCOPY NUMBER,
67 P_Purge_Stat_Lines OUT NOCOPY NUMBER,
68 P_Purge_Stat_Headers OUT NOCOPY NUMBER,
69 P_Purge_Stat_Rec OUT NOCOPY NUMBER,
70 P_Purge_Stat_Errors OUT NOCOPY NUMBER,
71 P_Purge_Inf_Headers2 OUT NOCOPY NUMBER,
72 P_Purge_Inf_Lines2 OUT NOCOPY NUMBER,
73 P_Purge_Stat_Lines2 OUT NOCOPY NUMBER,
74 P_Purge_Stat_Headers2 OUT NOCOPY NUMBER,
75 P_Archive_Inf_Headers OUT NOCOPY NUMBER,
76 P_Archive_Inf_Lines OUT NOCOPY NUMBER,
77 P_Archive_Stat_Headers OUT NOCOPY NUMBER,
78 P_Archive_Stat_Lines OUT NOCOPY NUMBER,
79 P_Archive_Stat_Errors OUT NOCOPY NUMBER,
80 P_Archive_Stat_Rec OUT NOCOPY NUMBER,
81 P_Archive_Inf_Lines2 OUT NOCOPY NUMBER,
82 P_Archive_Inf_Headers2 OUT NOCOPY NUMBER,
83 P_Archive_Stat_Lines2 OUT NOCOPY NUMBER,
84 P_Archive_Stat_Headers2 OUT NOCOPY NUMBER);
85
86
87 PROCEDURE delete_archive_tables;
88
89 PROCEDURE purge_process;
90
91 PROCEDURE arch_ce_statements;
92
93 PROCEDURE arch_ce_interface(p_intra_day_flag IN VARCHAR2);
94
95 PROCEDURE arch_ce_intra_statements;
96
97 PROCEDURE restore_process(errbuf OUT NOCOPY VARCHAR2,
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 ,
107 X_debug_path IN VARCHAR2
108 ); /* 10400780*/
109
110
111 END CE_PURGE;