1 PACKAGE PV_BENFT_STATUS_CHANGE AUTHID CURRENT_USER AS
2 /* $Header: pvstchgs.pls 115.3 2003/12/04 01:42:54 pklin noship $ */
3
4 PROCEDURE STATUS_CHANGE_NOTIFICATION(
5 p_api_version_number IN NUMBER,
6 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7 p_commit IN VARCHAR2 := FND_API.G_FALSE,
8 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9 P_BENEFIT_ID IN NUMBER,
10 P_STATUS IN VARCHAR2,
11 P_ENTITY_ID IN NUMBER,
12 P_PARTNER_ID IN NUMBER,
13 p_msg_callback_api IN VARCHAR2,
14 p_user_callback_api IN VARCHAR2,
15 p_user_role IN VARCHAR2 DEFAULT NULL,
16 x_return_status OUT NOCOPY VARCHAR2,
17 x_msg_count OUT NOCOPY NUMBER,
18 x_msg_data OUT NOCOPY VARCHAR2);
19
20 PROCEDURE STATUS_CHANGE_LOGGING(
21 p_api_version_number IN NUMBER,
22 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
23 p_commit IN VARCHAR2 := FND_API.G_FALSE,
24 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25 P_BENEFIT_ID IN NUMBER,
26 P_STATUS IN VARCHAR2,
27 P_ENTITY_ID IN NUMBER,
28 P_PARTNER_ID IN NUMBER,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2);
32
33 PROCEDURE REFERRAL_SET_MSG_ATTRS(
34 p_itemtype IN VARCHAR2,
35 p_itemkey IN VARCHAR2,
36 P_ENTITY_ID IN NUMBER,
37 P_USER_TYPE IN VARCHAR2,
38 P_STATUS IN VARCHAR2);
39
40 FUNCTION REFERRAL_RETURN_USERLIST(
41 p_benefit_type IN VARCHAR2,
42 P_ENTITY_ID IN NUMBER,
43 P_USER_ROLE IN VARCHAR2,
44 P_STATUS IN VARCHAR2) RETURN VARCHAR2;
45
46 FUNCTION STATUS_CHANGE_SUB(
47 p_subscription_guid in raw,
48 p_event in out nocopy wf_event_t) return varchar2;
49
50 FUNCTION CLAIM_REF_STATUS_CHANGE_SUB(
51 p_subscription_guid in raw,
52 p_event in out nocopy wf_event_t) return varchar2;
53
54 PROCEDURE STATUS_CHANGE_RAISE (
55 p_api_version_number IN NUMBER,
56 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57 p_commit IN VARCHAR2 := FND_API.G_FALSE,
58 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59 p_event_name IN VARCHAR2,
60 p_benefit_id IN NUMBER,
61 p_entity_id IN NUMBER,
62 p_status_code IN VARCHAR2,
63 p_partner_id IN NUMBER,
64 p_msg_callback_api IN VARCHAR2,
65 p_user_callback_api IN VARCHAR2,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2);
69
70
71
72 procedure GET_DECLINE_REASON (document_id in varchar2,
73 display_type in varchar2,
74 document in out nocopy varchar2,
75 document_type in out nocopy varchar2);
76
77 procedure GET_PRODUCTS (document_id in varchar2,
78 display_type in varchar2,
79 document in out nocopy varchar2,
80 document_type in out nocopy varchar2);
81
82
83 END;