PACKAGE: APPS.PO_AP_PURGE_PVT

Source

1 PACKAGE PO_AP_PURGE_PVT AUTHID CURRENT_USER AS
2 /* $Header: POXVPUDS.pls 115.0 2003/09/17 01:05:29 bao noship $ */
3 
4 -- <DOC PURGE FPJ START>
5 
6 PROCEDURE seed_records
7 (  p_api_version   IN NUMBER,
8    p_init_msg_list IN VARCHAR2,
9    p_commit        IN VARCHAR2,
10    x_return_status OUT NOCOPY VARCHAR2,
11    x_msg_data      OUT NOCOPY VARCHAR2,
12    p_purge_name     IN VARCHAR2,
13    p_purge_category IN VARCHAR2,
14    p_last_activity_date IN DATE
15 );
16 
17 
18 PROCEDURE filter_records
19 (  p_api_version   IN NUMBER,
20    p_init_msg_list IN VARCHAR2,
21    p_commit        IN VARCHAR2,
22    x_return_status OUT NOCOPY VARCHAR2,
23    x_msg_data      OUT NOCOPY VARCHAR2,
24    p_purge_status  IN VARCHAR2,
25    p_purge_name IN VARCHAR2,
26    p_purge_category IN VARCHAR2,
27    p_action         IN VARCHAR2,
28    x_po_records_filtered OUT NOCOPY VARCHAR2
29 );
30 
31 
32 
33 PROCEDURE confirm_records
34 (  p_api_version        IN NUMBER,
35    p_init_msg_list      IN VARCHAR2,
36    p_commit             IN VARCHAR2,
37    x_return_status      OUT NOCOPY VARCHAR2,
38    x_msg_data           OUT NOCOPY VARCHAR2,
39    p_purge_name         IN VARCHAR2,
40    p_purge_category     IN VARCHAR2,
41    p_last_activity_date IN DATE
42 );
43 
44 
45 PROCEDURE summarize_records
46 (  p_api_version        IN          NUMBER,
47    p_init_msg_list      IN          VARCHAR2,
48    p_commit             IN          VARCHAR2,
49    x_return_status      OUT NOCOPY  VARCHAR2,
50    x_msg_data           OUT NOCOPY  VARCHAR2,
51    p_purge_name         IN          VARCHAR2,
52    p_purge_category     IN          VARCHAR2,
53    p_range_size         IN          NUMBER
54 );
55 
56 
57 PROCEDURE delete_records
58 (  p_api_version    IN NUMBER,
59    p_init_msg_list  IN VARCHAR2,
60    p_commit         IN VARCHAR2,
61    x_return_status  OUT NOCOPY VARCHAR2,
62    x_msg_data       OUT NOCOPY VARCHAR2,
63    p_purge_name     IN VARCHAR2,
64    p_purge_category IN VARCHAR2,
65    p_range_size     IN NUMBER
66 );
67 
68 
69 PROCEDURE delete_purge_lists
70 (  p_api_version   IN NUMBER,
71    p_init_msg_list IN VARCHAR2,
72    p_commit        IN VARCHAR2,
73    x_return_status OUT NOCOPY VARCHAR2,
74    x_msg_data      OUT NOCOPY VARCHAR2,
75    p_purge_name     IN VARCHAR2
76 );
77 
78 
79 PROCEDURE delete_history_tables
80 (  p_api_version    IN NUMBER,
81    p_init_msg_list  IN VARCHAR2,
82    p_commit         IN VARCHAR2,
83    x_return_status  OUT NOCOPY VARCHAR2,
84    x_msg_data       OUT NOCOPY VARCHAR2,
85    p_purge_name     IN VARCHAR2
86 );
87 
88 
89 PROCEDURE count_po_rows
90 (  p_api_version    IN          NUMBER,
91    p_init_msg_list  IN          VARCHAR2,
92    x_return_status  OUT NOCOPY  VARCHAR2,
93    x_msg_data       OUT NOCOPY  VARCHAR2,
94    x_po_hdr_count   OUT NOCOPY  NUMBER,
95    x_rcv_line_count OUT NOCOPY  NUMBER,
96    x_req_hdr_count  OUT NOCOPY  NUMBER,
97    x_vendor_count   OUT NOCOPY  NUMBER,
98    x_asl_count      OUT NOCOPY  NUMBER,
99    x_asl_attr_count OUT NOCOPY  NUMBER,
100    x_asl_doc_count  OUT NOCOPY  NUMBER
101 );
102 
103 -- <DOC PURGE FPJ END>
104 
105 
106 
107 END PO_AP_PURGE_PVT;