1 PACKAGE XDP_Q_ADMIN_PKG AUTHID CURRENT_USER AS
2 /* $Header: XDPQADMS.pls 120.2 2006/04/10 23:21:35 dputhiye noship $ */
3
4 /********** Commented out - START - sacsharm - 11.5.6 **************
5
6 -- API specifications
7
8 -- Updates the queue state and initiates related processing, if any, depending on
9 -- the action code passed. Possible action code values are 'STARTUP', 'SHUTDOWN',
10 -- 'RESUME' and 'SUSPEND'.
11
12 PROCEDURE Update_Q_Status (
13 p_q_name IN VARCHAR2,
14 p_action_code IN VARCHAR2,
15 p_sql_code OUT NUMBER,
16 p_sql_desc OUT VARCHAR2);
17
18 -- Returns number of DQers running for an enabled queue
19
20 PROCEDURE Check_Q_Status (
21 p_q_name IN VARCHAR2,
22 p_dq_count OUT NUMBER,
23 p_sql_code OUT NUMBER,
24 p_sql_desc OUT VARCHAR2);
25
26 -- Enables the queue for processing and starts the asscociated DQer processes for the queue
27
28 PROCEDURE Start_Q (
29 p_q_name IN VARCHAR2,
30 p_q_display_name IN VARCHAR2,
31 p_q_state IN VARCHAR2,
32 p_q_count IN NUMBER,
33 p_max_tries IN NUMBER DEFAULT 1,
34 p_caller IN VARCHAR2 DEFAULT 'NON_CONC_JOB',
35 p_sql_code OUT NUMBER,
36 p_sql_desc OUT VARCHAR2);
37
38
39 -- Enables all queues for processing and starts the asscociated DQer processes for the queue
40
41 PROCEDURE Start_All_Qs (
42 p_caller IN VARCHAR2 DEFAULT 'CONC_JOB',
43 p_sql_code OUT NUMBER,
44 p_sql_desc OUT VARCHAR2);
45
46 -- Gets the sorted list (latest first) of exception messages associated with the queue.
47 -- Message text is in user's language and has parameter tokens substituted with the values.
48
49 PROCEDURE Get_Q_Errors (
50 p_q_name IN VARCHAR2,
51 p_message_list OUT XDP_TYPES.MESSAGE_LIST,
52 p_sql_code OUT NUMBER,
53 p_sql_desc OUT VARCHAR2);
54
55 *********** Commented out - END - sacsharm - 11.5.6 *************/
56
57 END XDP_Q_ADMIN_PKG;