PACKAGE: APPS.ASP_ALERTS_PUB

Source

1 PACKAGE ASP_ALERTS_PUB as
2 /* $Header: asppalts.pls 120.2 2005/09/13 17:20 axavier noship $ */
3 ---------------------------------------------------------------------------
4 -- Package Name:   ASP_ALERTS_PUB
5 ---------------------------------------------------------------------------
6 -- Description:
7 --      Public package for Sales Alerts Related Business logic.
8 --
9 -- Procedures:
10 --   (see below for specification)
11 --
12 -- History:
13 --   08-Aug-2005  axavier created.
14 ---------------------------------------------------------------------------
15 
16 /*-------------------------------------------------------------------------*
17  |                             PUBLIC CONSTANTS
18  *-------------------------------------------------------------------------*/
19 
20 /*-------------------------------------------------------------------------*
21  |                             PUBLIC DATATYPES
22  *-------------------------------------------------------------------------*/
23   TYPE SUBSCRIBER_REC_TYPE IS RECORD
24   (
25     SUBSCRIPTION_ID NUMBER default null,
26     SUBSCRIBER_NAME VARCHAR2(320) default null,
27     DELIVERY_CHANNEL  VARCHAR2(30) default null,
28     USER_ID NUMBER default null
29   );
30   TYPE  subscriber_tbl_type IS TABLE OF subscriber_rec_type
31                                     INDEX BY BINARY_INTEGER;
32 
33 /*-------------------------------------------------------------------------*
34  |                             PUBLIC VARIABLES
35  *-------------------------------------------------------------------------*/
36 
37 /*-------------------------------------------------------------------------*
38  |                             PUBLIC ROUTINES
39  *-------------------------------------------------------------------------*/
40 
41 --------------------------------------------------------------------------------
42 --
43 --  Procedure: Get_Matching_Subscriptions
44 --   This method returns all the subscribers of a given Alert.
45 --
46 --  Arguments IN/OUT:
47 --   l_api_version  - 1.0
48 --   p_init_msg_list   - Message Stack to be initialized or not.
49 --   p_alert_code     - Alert code corresponding to the asp_alert_subscriptions.alert_code
50 --   x_subscriber_list  - table of record of subscribers.
51 --   x_return_status -   S Success; U Un Expected; E Error
52 --   x_msg_count -   Number of messages in the Message Stack.
53 --   x_msg_data -   First Message in the Message Stack.
54 --
55 --------------------------------------------------------------------------------
56 
57 PROCEDURE Get_Matching_Subscriptions (
58   p_api_version_number  IN  NUMBER,
59   p_init_msg_list       IN  VARCHAR2   DEFAULT  FND_API.G_FALSE,
60   p_alert_code          IN  VARCHAR2,
61   p_customer_id         IN  NUMBER,
62   x_subscriber_list     OUT NOCOPY  SUBSCRIBER_TBL_TYPE,
63   x_return_status       OUT NOCOPY  VARCHAR2,
64   x_msg_count           OUT NOCOPY  NUMBER,
65   x_msg_data            OUT NOCOPY  VARCHAR2);
66 
67 
68 END ASP_ALERTS_PUB;