1 PACKAGE ego_pub_hist_purge_pkg AUTHID CURRENT_USER AS
2 /* $Header: EGOPPHPS.pls 120.1.12020000.2 2013/03/06 07:38:59 evwang ship $ */
3
4 -- ============================================================================
5 -- Name : Purge_Publish_History
6 --
7 --
8 -- Description : This procedure will be used to delete publish history based on
9 -- input parameter passed.
10 --
11 -- IN :
12 -- p_batch_id IN NUMBER
13 -- A unique batch identifier.
14 --
15 -- p_target_system_code IN VARCHAR2
16 -- Sytem identification code into which entities are published.
17 --
18 -- p_from_date IN DATE
19 -- From date for a date Range.
20 --
21 -- p_to_date IN DATE
22 -- To date for a date Range.
23 --
24 -- p_status_code IN VARCHAR2
25 -- Status of the entity i.e. Successful,In-Progress etc.
26 --
27 -- p_published_by IN NUMBER
28 -- Publisher of Entity/Batch.
29 --
30 -- p_entity_type IN VARCHAR2
31 -- Type of the Entity, which you want to delete
32 --
33 -- OUT :
34 -- err_buff OUT VARCHAR2
35 -- standard out parameter to handle error message
36 --
37 -- ret_code OUT NUMBER
38 -- standard out parameter to return API execution status
39 -- ============================================================================
40
41 PROCEDURE Purge_Publish_History ( err_buff IN OUT NOCOPY VARCHAR2,
42 ret_code OUT NOCOPY NUMBER,
43 p_batch_id IN NUMBER ,
44 p_target_system_code IN VARCHAR2 ,
45 p_from_date IN VARCHAR2 ,
46 p_to_date IN VARCHAR2 ,
47 p_status_code IN VARCHAR2 ,
48 p_published_by IN NUMBER ,
49 p_entity_type IN VARCHAR2);
50 PROCEDURE Purge_Publish_History_By_Batch(ERRBUF IN OUT NOCOPY VARCHAR2,
51 RETCODE OUT NOCOPY VARCHAR2,
52 p_batch_id_list varchar2,
53 p_purge_days IN NUMBER,
54 p_batch_name1 varchar2,
55 p_batch_name2 varchar2,
56 p_batch_name3 varchar2,
57 p_batch_name4 varchar2,
58 p_batch_name5 varchar2
59 );
60 TYPE ARRAY IS TABLE OF VARCHAR2(255) ;
61 TYPE ARRAY2 IS TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
62 END ego_pub_hist_purge_pkg;