1 PACKAGE AP_PURGE_PKG AUTHID CURRENT_USER AS
2 /* $Header: appurges.pls 120.0.12020000.2 2012/07/06 09:51:45 kpasikan ship $ */
3
4 FUNCTION Set_Purge_Status
5 (P_Status IN VARCHAR2,
6 P_Purge_Name IN VARCHAR2,
7 P_Debug_Switch IN VARCHAR2,
8 P_Calling_Sequence IN VARCHAR2)
9 RETURN BOOLEAN;
10
11
12 FUNCTION Check_no_purge_in_process
13 (P_Purge_Name IN VARCHAR2,
14 P_Debug_Switch IN VARCHAR2,
15 P_Calling_Sequence IN VARCHAR2)
16 RETURN BOOLEAN;
17
18
19 FUNCTION Seed_purge_tables
20 (P_Category IN VARCHAR2,
21 P_Purge_Name IN VARCHAR2,
22 P_Activity_Date IN DATE,
23 P_Organization_ID IN NUMBER,
24 P_PA_Status IN VARCHAR2,
25 P_Purchasing_Status IN VARCHAR2,
26 P_Payables_Status IN VARCHAR2,
27 P_Assets_Status IN VARCHAR2,
28 P_Chv_Status IN VARCHAR2,
29 P_EDI_Status IN VARCHAR2,
30 P_MRP_Status IN VARCHAR2,
31 P_Debug_Switch IN VARCHAR2,
32 P_calling_sequence IN VARCHAR2)
33 RETURN BOOLEAN;
34
35
36 FUNCTION Create_Summary_Records(p_purge_name IN VARCHAR2,
37 p_category IN VARCHAR2,
38 p_range_size IN NUMBER,
39 p_debug_switch IN VARCHAR2,
40 p_calling_sequence IN VARCHAR2)
41 RETURN BOOLEAN;
42
43
44 FUNCTION Confirm_Seeded_Data(P_Status IN VARCHAR2,
45 P_Category IN VARCHAR2,
46 P_Purge_Name IN VARCHAR2,
47 P_Activity_Date IN DATE,
48 P_Organization_ID IN NUMBER,
49 P_PA_Status IN VARCHAR2,
50 P_Purchasing_Status IN VARCHAR2,
51 P_Payables_Status IN VARCHAR2,
52 P_Assets_Status IN VARCHAR2,
53 P_Chv_Status IN VARCHAR2,
54 P_EDI_Status IN VARCHAR2,
55 P_MRP_Status IN VARCHAR2,
56 P_Debug_Switch IN VARCHAR2,
57 p_calling_sequence IN VARCHAR2)
58 RETURN BOOLEAN;
59
60
61 FUNCTION Delete_Seeded_Data
62 (P_Purge_Name IN VARCHAR2,
63 P_Category IN VARCHAR2,
64 P_activity_Date IN DATE,
65 P_Range_Size IN NUMBER,
66 P_Purchasing_Status IN VARCHAR2,
67 P_MRP_Status IN VARCHAR2,
68 P_Debug_Switch IN VARCHAR2,
69 P_Calling_Sequence IN VARCHAR2)
70 RETURN BOOLEAN;
71
72
73 FUNCTION Abort_Purge
74 (P_Purge_Name IN VARCHAR2,
75 P_Original_Status IN VARCHAR2,
76 P_Debug_Switch IN VARCHAR2,
77 P_Calling_Sequence IN VARCHAR2)
78 RETURN BOOLEAN;
79
80
81 -- Bug 14237038 (11i-8913560)
82 PROCEDURE Purge_acctg_and_ap_table
83 (errbuf IN OUT NOCOPY VARCHAR2,
84 retcode IN OUT NOCOPY VARCHAR2,
85 P_batch_size IN VARCHAR2,
86 P_Worker_Id IN NUMBER,
87 P_Num_Workers IN NUMBER,
88 P_Script_Name IN VARCHAR2,
89 P_Debug_Switch IN VARCHAR2 DEFAULT NULL,
90 p_purge_name IN VARCHAR2 DEFAULT NULL) ;
91
92 END AP_PURGE_PKG;
[Home] [Help]