1 PACKAGE DPP_BUSINESSEVENTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: dppvbevs.pls 120.2.12010000.4 2009/06/10 06:32:21 pvaramba ship $ */
3
4 TYPE dpp_txn_hdr_rec_type IS RECORD
5 (
6 Transaction_Header_ID NUMBER,
7 Transaction_number VARCHAR2(240),
8 Process_code VARCHAR2(240),
9 claim_id NUMBER,
10 claim_type_flag VARCHAR2(30),
11 claim_creation_source VARCHAR2(20)
12 );
13
14
15 TYPE dpp_txn_line_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
16
17 ---------------------------------------------------------------------
18 -- PROCEDURE
19 -- Raise_Business_Event
20 --
21 -- PURPOSE
22 -- Raise Business event
23 --
24 -- PARAMETERS
25 --
26 -- NOTES
27 -- 1.
28 -- 2.
29 ----------------------------------------------------------------------
30 PROCEDURE Raise_Business_Event(
31 p_api_version IN NUMBER
32 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
33 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
34 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
35
36 ,x_return_status OUT NOCOPY VARCHAR2
37 ,x_msg_count OUT NOCOPY NUMBER
38 ,x_msg_data OUT NOCOPY VARCHAR2
39
40 ,p_txn_hdr_rec IN dpp_txn_hdr_rec_type
41 ,p_txn_line_id IN dpp_txn_line_tbl_type
42 );
43
44 ---------------------------------------------------------------------
45 -- PROCEDURE
46 -- RAISE_EFFECTIVE_DATE_EVENT
47 --
48 -- PURPOSE
49 -- Raise a business event on the effective date of a txn.
50 --
51 -- PARAMETERS
52 -- program id of the cc program which does the status change.
53 --
54 ----------------------------------------------------------------------
55 PROCEDURE RAISE_EFFECTIVE_DATE_EVENT(
56 P_API_VERSION IN NUMBER,
57 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
58 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59 P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
60 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
61 X_MSG_DATA OUT NOCOPY VARCHAR2,
62 X_MSG_COUNT OUT NOCOPY NUMBER,
63 P_PROGRAM_ID IN NUMBER );
64
65 ---------------------------------------------------------------------
66 -- PROCEDURE
67 -- SEND_EFFECTIVE_DATE_NOTIF
68 --
69 -- PURPOSE
70 -- Called by the wf to send notif to the user
71 --
72 ----------------------------------------------------------------------
73 PROCEDURE SEND_EFFECTIVE_DATE_NOTIF(
74 ITEMTYPE IN VARCHAR2,
75 ITEMKEY IN VARCHAR2,
76 ACTID IN NUMBER,
77 FUNCMODE IN VARCHAR2,
78 RESULT IN OUT NOCOPY VARCHAR2
79 );
80
81 ---------------------------------------------------------------------
82 -- PROCEDURE
83 -- SEND_CANCEL_NOTIFICATIONS
84 --
85 -- PURPOSE
86 -- Procedure to invoke the cancel notifications.
87 --
88 ----------------------------------------------------------------------
89 PROCEDURE SEND_CANCEL_NOTIFICATIONS(
90 P_API_VERSION IN NUMBER,
91 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
92 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
93 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
94 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
95 X_MSG_COUNT OUT NOCOPY NUMBER,
96 X_MSG_DATA OUT NOCOPY VARCHAR2,
97 P_TXN_HDR_ID IN NUMBER
98 );
99
100 ---------------------------------------------------------------------
101 -- PROCEDURE
102 -- RAISE_BUSINESS_EVT_FOR_PROCESS
103 --
104 -- PURPOSE
105 -- Raises the business event for the specified process.
106 --
107 ----------------------------------------------------------------------
108 PROCEDURE RAISE_BUSINESS_EVT_FOR_PROCESS (
109 P_API_VERSION IN NUMBER,
110 P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
111 P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
112 P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
114 X_MSG_COUNT OUT NOCOPY NUMBER,
115 X_MSG_DATA OUT NOCOPY VARCHAR2,
116 P_TXN_HDR_ID IN NUMBER,
117 P_PROCESS_CODE IN VARCHAR2
118 );
119
120
121 END DPP_BUSINESSEVENTS_PVT;