DBA Data[Home] [Help]

PACKAGE: APPS.OE_MESSAGE_PURGE_PVT

Source


1 PACKAGE OE_MESSAGE_PURGE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXMPRGS.pls 120.2 2005/09/29 01:48:00 pkannan noship $ */
3 
4 /* ---------------------------------------------------------------
5 --  Start of Comments
6 --  API name    OE_MESSAGE_PURGE_PVT
7 --  Type        Private
8 --  Function
9 --  Pre-reqs
10 --  Parameters
11 --  Version     Current version = 1.0
12 --              Initial version = 1.0
13 --  Notes
14 --
15 --  End of Comments
16 ------------------------------------------------------------------ */
17 
18 /* -----------------------------------------------------------
19    Procedure: Purge_Messages
20  ----------------------------------------------------------- */
21 PROCEDURE PURGE(
22 errbuf OUT NOCOPY VARCHAR2
23 
24 ,retcode OUT NOCOPY NUMBER
25 
26   ,p_commit IN NUMBER DEFAULT 500
27   ,p_start_date IN VARCHAR2
28   ,p_end_date IN VARCHAR2
29   ,p_message_source IN VARCHAR2
30   ,p_customer_id_name IN NUMBER
31   ,p_customer_id_number IN NUMBER
32   ,p_order_type_id IN NUMBER
33   ,p_start_order_num IN NUMBER
34   ,p_end_order_num IN NUMBER
35   ,p_message_status_code IN Varchar2 Default Null);
36 
37 END OE_MESSAGE_PURGE_PVT;