1 PACKAGE AS_BUSINESS_EVENT_PVT AUTHID CURRENT_USER as
2 /* $Header: asxvbevs.pls 115.0 2003/11/21 13:06:42 sumahali noship $ */
3
4 DIRECT_CALL CONSTANT VARCHAR2(16) := '__DIRECT_CALL__';
5
6 OPPTY_WON_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.as.opportunity.update_wonStatus';
7 OPPTY_LOST_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.as.opportunity.update_lostStatus';
8 OPPTY_CLOSED_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.as.opportunity.update_closedStatus';
9 OPPTY_UPDATE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.as.opportunity.update_header';
10 OPP_LINES_UPDATE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.as.opportunity.update_lines';
11 OPP_STEAM_UPDATE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.as.opportunity.update_salesteam';
12 CUST_STEAM_UPDATE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.as.customer.update_salesteam';
13
14 INT_OPPTY_UPDATE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.as.opportunity.int_update_header';
15 INT_OPP_LINES_UPDATE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.as.opportunity.int_update_lines';
16 -- The Below internal event is for both Opportunity and customer Sales Teams
17 INT_STEAM_UPDATE_EVENT CONSTANT VARCHAR2(240) := 'oracle.apps.as.opportunity.int_update_salesteam';
18
19 -- Start of Comments
20 --
21 -- NAME
22 -- AS_BUSINESS_EVENT_PVT
23 --
24 -- PURPOSE
25 -- This package is a private package which contains procedures and functions
26 -- to raise opportunity related business events. This is NOT an API package
27 --
28 -- Procedures:
29 --
30 --
31 --
32 -- HISTORY
33 -- 9/17/03 SUMAHALI created
34 --
35 -- End of Comments
36
37 PROCEDURE raise_event
38 ----------------------------------------------
39 -- Check if Event exist
40 -- Check if Event is like 'oracle.apps.as.%'
41 -- Get the item_key
42 -- Raise event
43 ----------------------------------------------
44 (p_event_name IN VARCHAR2,
45 p_event_key IN VARCHAR2,
46 p_data IN CLOB DEFAULT NULL,
47 p_parameters IN wf_parameter_list_t DEFAULT NULL);
48
49 PROCEDURE Before_Oppty_Update(
50 p_lead_id IN NUMBER,
51 x_event_key OUT NOCOPY VARCHAR2
52 );
53
54 PROCEDURE Update_oppty_post_event(
55 p_lead_id IN NUMBER,
56 p_event_key IN VARCHAR2
57 );
58
59 PROCEDURE Before_Opp_Lines_Update(
60 p_lead_id IN NUMBER,
61 x_event_key OUT NOCOPY VARCHAR2
62 );
63
64 PROCEDURE Upd_Opp_Lines_post_event(
65 p_lead_id IN NUMBER,
66 p_event_key IN VARCHAR2
67 );
68
69 PROCEDURE Before_Opp_STeam_Update(
70 p_lead_id IN NUMBER,
71 x_event_key OUT NOCOPY VARCHAR2
72 );
73
74 PROCEDURE Upd_Opp_STeam_post_event(
75 p_lead_id IN NUMBER,
76 p_event_key IN VARCHAR2
77 );
78
79 PROCEDURE Before_Cust_STeam_Update(
80 p_cust_id IN NUMBER,
81 x_event_key OUT NOCOPY VARCHAR2
82 );
83
84 PROCEDURE Upd_Cust_STeam_post_event(
85 p_cust_id IN NUMBER,
86 p_event_key IN VARCHAR2
87 );
88
89 FUNCTION Event_data_delete
90 -- Rule function for event data deletions used as the last subscription to AS events
91 (p_subscription_guid IN RAW,
92 p_event IN OUT NOCOPY WF_EVENT_T)
93 RETURN VARCHAR2;
94
95 FUNCTION Raise_update_oppty_event (
96 p_subscription_guid IN RAW,
97 p_event IN OUT NOCOPY WF_EVENT_T
98 )
99 RETURN VARCHAR2;
100
101 FUNCTION Raise_upd_opp_lines_evnt (
102 p_subscription_guid IN RAW,
103 p_event IN OUT NOCOPY WF_EVENT_T
104 )
105 RETURN VARCHAR2;
106
107 FUNCTION Raise_upd_STeam_evnt (
108 p_subscription_guid IN RAW,
109 p_event IN OUT NOCOPY WF_EVENT_T
110 )
111 RETURN VARCHAR2;
112
113 -- This function is for subscribing, for testing/debugging of business events,
114 -- to business events raised by Opportunity and customer sales team modules
115 -- which log data to as_event_data table. It creates a new event_key like
116 -- 'debug<sequence>', The first rows contain the parameters one by one. The
117 -- parameter name is stored in CHAR01 and value in CHAR02. The subsequent rows
118 -- contain as_event_data corresponding to the event key received.
119 -- The original event key is stored in CHAR80.
120 -- It is the users responsibility to delete these debug rows from the
121 -- as_event_data table.
122 FUNCTION Test_event
123 -- Rule function for event data deletions used as the last subscription to AS events
124 (p_subscription_guid IN RAW,
125 p_event IN OUT NOCOPY WF_EVENT_T)
126 RETURN VARCHAR2;
127
128 END AS_BUSINESS_EVENT_PVT;