[Home] [Help]
PACKAGE: APPS.PO_AP_PURGE_GRP
Source
1 PACKAGE PO_AP_PURGE_GRP AUTHID CURRENT_USER AS
2 /* $Header: POXGPUDS.pls 115.0 2003/09/17 00:59:20 bao noship $ */
3
4 -- Purge Category
5 G_PUR_CAT_SIMPLE_REQ CONSTANT VARCHAR2(30) := 'SIMPLE REQUISITIONS';
6 G_PUR_CAT_SIMPLE_PO CONSTANT VARCHAR2(30) := 'SIMPLE POS';
7 G_PUR_CAT_MATCHED_PO_INV CONSTANT VARCHAR2(30) := 'MATCHED POS AND INVOICES';
8
9 -- Filter Action
10 G_FILTER_ACT_REF_PO_REQ CONSTANT VARCHAR2(30) := 'FILTER REF PO AND REQ';
11 G_FILTER_ACT_DEP_PO_REQ CONSTANT VARCHAR2(30) := 'FILTER DEPENDENT PO AND REQ';
12 G_FILTER_ACT_DEP_PO_AP CONSTANT VARCHAR2(30) := 'FILTER DEPENDENT PO AND AP';
13
14 FUNCTION validate_purge
15 (
16 p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
17 )
18 RETURN VARCHAR2;
19
20
21 PROCEDURE purge
22 (
23 p_api_version IN NUMBER,
24 x_return_status OUT NOCOPY VARCHAR2
25 );
26
27 FUNCTION referencing_docs_exist
28 ( p_po_header_id IN PO_HEADERS_ALL.po_header_id%TYPE
29 ) RETURN BOOLEAN;
30
31
32 -- <DOC PURGE FPJ START>
33
34 PROCEDURE seed_records
35 ( p_api_version IN NUMBER,
36 p_init_msg_list IN VARCHAR2,
37 p_commit IN VARCHAR2,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 p_purge_name IN VARCHAR2,
41 p_purge_category IN VARCHAR2,
42 p_last_activity_date IN DATE
43 );
44
45
46
47 PROCEDURE filter_records
48 ( p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2,
50 p_commit IN VARCHAR2,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_data OUT NOCOPY VARCHAR2,
53 p_purge_status IN VARCHAR2,
54 p_purge_name IN VARCHAR2,
55 p_purge_category IN VARCHAR2,
56 p_action IN VARCHAR2,
57 x_po_records_filtered OUT NOCOPY VARCHAR2
58 );
59
60
61
62 PROCEDURE confirm_records
63 ( p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2,
65 p_commit IN VARCHAR2,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_purge_name IN VARCHAR2,
69 p_purge_category IN VARCHAR2,
70 p_last_activity_date IN DATE
71 );
72
73
74 PROCEDURE summarize_records
75 ( p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2,
77 p_commit IN VARCHAR2,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_data OUT NOCOPY VARCHAR2,
80 p_purge_name IN VARCHAR2,
81 p_purge_category IN VARCHAR2,
82 p_range_size IN NUMBER
83 );
84
85
86 PROCEDURE delete_records
87 ( p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2,
89 p_commit IN VARCHAR2,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_purge_name IN VARCHAR2,
93 p_purge_category IN VARCHAR2,
94 p_range_size IN NUMBER
95 );
96
97
98 PROCEDURE delete_purge_lists
99 ( p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2,
101 p_commit IN VARCHAR2,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_purge_name IN VARCHAR2
105 );
106
107
108 PROCEDURE delete_history_tables
109 ( p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2,
111 p_commit IN VARCHAR2,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_purge_name IN VARCHAR2
115 );
116
117
118 PROCEDURE count_po_rows
119 ( p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 x_po_hdr_count OUT NOCOPY NUMBER,
124 x_rcv_line_count OUT NOCOPY NUMBER,
125 x_req_hdr_count OUT NOCOPY NUMBER,
126 x_vendor_count OUT NOCOPY NUMBER,
127 x_asl_count OUT NOCOPY NUMBER,
128 x_asl_attr_count OUT NOCOPY NUMBER,
129 x_asl_doc_count OUT NOCOPY NUMBER
130 );
131
132 -- <DOC PURGE FPJ END>
133
134 END PO_AP_PURGE_GRP;