PACKAGE: APPS.AMS_TCOP_SCHEDULER_PKG

Source

1 PACKAGE AMS_TCOP_SCHEDULER_PKG AUTHID CURRENT_USER AS
2 /* $Header: amsvtcss.pls 115.1 2003/11/17 18:54:51 rmajumda noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --          AMS_TCOP_SCHEDULER_PKG
7 -- Purpose
8 --
9 -- This package contains all the program units for traffic cop
10 -- Scheduler
11 --
12 -- History
13 --
14 -- NOTE
15 --
16 -- End of Comments
17 -- ===============================================================
18 -- Start of Comments
19 -- Name
20 -- Enqueue
21 --
22 -- Purpose
23 -- This procedure adds a request to the Traffic Cop Processing Queue
24 --
25 Procedure Enqueue(
26   p_schedule_id NUMBER,
27   p_item_type   VARCHAR2,
28   p_item_id     VARCHAR2
29 ) ;
30 
31 -- ===============================================================
32 -- Start of Comments
33 -- Name
34 -- Is_This_Schedule_Ready_To_Run
35 --
36 -- Purpose
37 -- This function returns 'Y' if the Schedule is ready to run
38 -- It returns 'N' if the Schedule is not scheduled to Run
39 --
40 FUNCTION 	Is_This_Schedule_Ready_To_Run(
41           	 p_schedule_id NUMBER
42 )
43 RETURN VARCHAR2;
44 
45 PROCEDURE DEQUEUE (errbuf     OUT   NOCOPY   VARCHAR2,
46                    retcode    OUT   NOCOPY   NUMBER
47                   );
48 
49 PROCEDURE   UPDATE_STATUS(p_schedule_id   NUMBER,
50                           p_status        VARCHAR2
51                         );
52 
53 
54 
55 END AMS_TCOP_SCHEDULER_PKG;