PACKAGE: APPS.JTF_IH_PURGE

Source

1 PACKAGE JTF_IH_PURGE AS
2 /* $Header: JTFIHPRS.pls 120.2 2005/07/02 02:07:47 appldev ship $ */
3 -- G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_IH_PURGE';
4 -- Program History
5 -- 09-OCT-2002  Igor Aleshin    Created.
6 -- 26-NOV-2002  Igor Aleshin    Added parameters: Outcome, Result, Reason for Activity and Interaction
7 -- 13-JAN-2003  Igor Aleshin    Added parameter p_Active default 'N'
8 -- 07-MAY-2004	Igor Aleshin	Fixed File.sql.35 issue
9 -- 29-DEC-2004	Neha Chourasia	Bug 4063673 fix for date range purge not working for Active set to Y
10 -- 25-FEB-2005	Neha Chourasia	ER 4007013 Added API PURGE_BY_OBJECT to purge interactions and
11 --                              activities related to the object passed.
12 
13 
14     TranRows NUMBER;        -- How many deleted rows has each transaction.
15     p_commit VARCHAR2(1);    -- Commit or not.
16     PROCEDURE PURGE(ERRBUF OUT NOCOPY VARCHAR2, RETCODE OUT NOCOPY VARCHAR2,
17         p_Party_IDs VARCHAR2 DEFAULT NULL,
18         p_Party_Type VARCHAR2 DEFAULT NULL,
19         p_Active VARCHAR2 DEFAULT NULL, -- Bug# 4063673 - changed position from last param to 3rd
20         p_Start_Date DATE DEFAULT NULL,
21         p_End_Date DATE DEFAULT NULL,
22         p_SafeMode VARCHAR2 DEFAULT NULL,
23         p_Purge_Type VARCHAR2 DEFAULT NULL,
24         -- Added 26-NOV-2002
25         p_ActivityOutcome VARCHAR2 DEFAULT NULL,
26         p_ActivityResult VARCHAR2 DEFAULT NULL,
27         p_ActivityReason VARCHAR2 DEFAULT NULL,
28         p_InterOutcome VARCHAR2 DEFAULT NULL,
29         p_InterResult VARCHAR2 DEFAULT NULL,
30         p_InterReason VARCHAR2 DEFAULT NULL
31         );
32   PROCEDURE P_DELETE_INTERACTIONS (
33         p_api_version      IN NUMBER,
34         p_init_msg_list  IN VARCHAR2 ,
35         p_commit          IN  VARCHAR2,
36         x_return_status  OUT NOCOPY VARCHAR2,
37         x_msg_data        OUT  NOCOPY VARCHAR2,
38         x_msg_count      OUT  NOCOPY NUMBER,
39         p_processing_set_id IN NUMBER,
40         p_object_type IN VARCHAR2
41         );
42 END;