[Home] [Help]
PACKAGE: APPS.OKC_DELIVERABLE_WF_PVT
Source
1 PACKAGE OKC_DELIVERABLE_WF_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVDELWFS.pls 120.0.12020000.2 2013/04/16 19:27:24 nbingi ship $ */
3
4 ---------------------------------------------------------------------------
5 -- Global VARIABLES
6 ---------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_DELIVERABLE_WF_PVT';
8 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
9
10 ------------------------------------------------------------------------------
11 -- GLOBAL CONSTANTS
12 ------------------------------------------------------------------------------
13 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
14 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
15 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
17 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
18 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
19 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
20 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
21
22 ---------------------------------------------------------------------------
23 -- Procedures and Functions
24 ---------------------------------------------------------------------------
25 procedure deliverables_notifier(
26 p_api_version IN NUMBER:=1.0,
27 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
28 p_deliverable_id IN NUMBER,
29 p_deliverable_name IN VARCHAR2,
30 p_deliverable_type IN VARCHAR2,
31 p_business_document_id IN NUMBER,
32 p_business_document_version IN NUMBER,
33 p_business_document_type IN VARCHAR2,
34 p_business_document_number IN VARCHAR2,
35 p_resp_party IN VARCHAR2,
36 p_external_contact IN NUMBER,
37 p_internal_contact IN NUMBER,
38 p_requester_id IN NUMBER default null,
39 p_notify_prior_due_date_value IN VARCHAR2 default null,
40 p_notify_prior_due_date_uom IN VARCHAR2 default null,
41 p_msg_code IN VARCHAR2,
42 x_notification_id OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_return_status OUT NOCOPY VARCHAR2);
46
47 PROCEDURE get_subject_text (document_id in varchar2,
48 display_type in varchar2,
49 document in out nocopy varchar2,
50 document_type in out nocopy varchar2);
51
52 procedure set_int_notif_id (itemtype in varchar2,
53 itemkey in varchar2,
54 actid in number,
55 funcmode in varchar2,
56 resultout out nocopy varchar2);
57
58 procedure set_ext_notif_id (itemtype in varchar2,
59 itemkey in varchar2,
60 actid in number,
61 funcmode in varchar2,
62 resultout out nocopy varchar2);
63
64 procedure update_status (itemtype in varchar2,
65 itemkey in varchar2,
66 actid in number,
67 funcmode in varchar2,
68 resultout out nocopy varchar2);
69
70 function send_notification_bus_event (p_subscription_guid in raw,
71 p_event in out nocopy WF_EVENT_T) return varchar2;
72
73 PROCEDURE get_notfn_body(document_id IN VARCHAR2,
74 display_type IN VARCHAR2,
75 document IN OUT NOCOPY CLOB,
76 document_type IN OUT NOCOPY VARCHAR2);
77 END OKC_DELIVERABLE_WF_PVT;