1 package FND_PURGE AUTHID CURRENT_USER as
2 /* $Header: AFCPPURS.pls 115.0 99/09/29 17:52:24 porting ship $ */
3
4 TYPE requests_record_type is record
5 (request_id number);
6
7 TYPE requests_tab_type is table of requests_record_type
8 index by binary_integer;
9
10 TYPE managers_record_type is record
11 (process_id number);
12
13 TYPE managers_tab_type is table of managers_record_type
14 index by binary_integer;
15
16 --
17 -- Name
18 -- requests
19 --
20 -- Purpose
21 -- It will purge the records that are belongs to a concurrent request.
22 -- Arguments
23 -- rec_table : pl/sql table with request_id a one field.
24 -- start_range : starting number of the record in the rec_table for which
25 -- purge is required.
26 -- end_range : ending number of the record in the rec_table for which
27 -- purge is recuired.
28 --
29
30 PROCEDURE requests( rec_table IN requests_tab_type,
31 start_range IN NUMBER,
32 end_range IN NUMBER);
33 --
34 -- Name
35 -- managers
36 --
37 -- Purpose
38 -- It will purge the records that are belongs to a concurrent managers.
39 -- Arguments
40 -- rec_table : pl/sql table with process_id as one field.
41 -- start_range : starting number of the record in the rec_table for which
42 -- purge is required.
43 -- end_range : ending number of the record in the rec_table for which
44 -- purge is recuired.
45 --
46
47 PROCEDURE managers( rec_table IN managers_tab_type,
48 start_range IN NUMBER,
49 end_range IN NUMBER);
50
51 end FND_PURGE;