[Home] [Help]
PACKAGE: APPS.OKC_AQ_PUB
Source
1 Package OKC_AQ_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPAQS.pls 120.0 2005/05/26 09:34:07 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- SUB TYPES
7 subtype corrid_rec_typ is okc_aq_pvt.corrid_rec_typ;
8 subtype msg_tab_typ is okc_aq_pvt.msg_tab_typ;
9 ---------------------------------------------------------------------------
10 -- CONSTANTS
11 ---------------------------------------------------------------------------
12 g_msg_expire CONSTANT BINARY_INTEGER default dbms_aq.never;
13 g_event_queue_name CONSTANT VARCHAR2(100) default OKC_QUEUE_PVT.event_queue_name;
14 g_outcome_queue_name CONSTANT VARCHAR2(100) default OKC_QUEUE_PVT.outcome_queue_name;
15 g_dequeue_wait CONSTANT BINARY_INTEGER default 5;
16 ---------------------------------------------------------------------------
17
18 -- PUBLIC VARIABLES
19 ---------------------------------------------------------------------------
20 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_AQ_PUB';
21 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
22 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
23 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
24 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
25 --------------------------------------------------------------------------
26 -- GLOBAL EXCEPTIONS
27 ---------------------------------------------------------------------------
28 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
29
30 ------------------------------------------------------------------------------
31
32 -- Procedures and Functions
33 ---------------------------------------------------------------------------
34 -- overloaded send_message procedure supports
35 -- varchar2 and clob message payloads
36
37 PROCEDURE send_message
38 (p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 DEFAULT okc_api.G_FALSE,
40 p_commit IN VARCHAR2 DEFAULT okc_api.G_FALSE,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43 x_return_status OUT NOCOPY VARCHAR2,
44 p_corrid_rec IN okc_aq_pub.corrid_rec_typ,
45 p_msg_tab IN okc_aq_pub.msg_tab_typ,
46 p_queue_name IN VARCHAR2,
47 p_delay IN INTEGER default dbms_aq.no_delay
48 );
49
50 /*PROCEDURE send_message
51 (p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT okc_api.G_FALSE,
53 p_commit IN VARCHAR2 DEFAULT okc_api.G_FALSE,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 x_return_status OUT NOCOPY VARCHAR2,
57 p_msg IN VARCHAR2,
58 p_queue_name IN VARCHAR2,
59 p_delay IN number default 0
60 ); */
61
62 END okc_aq_pub;