[Home] [Help]
PACKAGE: APPS.ENG_WORKFLOW_NTF_UTIL
Source
1 PACKAGE Eng_Workflow_Ntf_Util AS
2 /* $Header: ENGUNTFS.pls 120.2 2006/02/18 20:08:19 mkimizuk noship $ */
3
4
5 -- Message Attribute Record
6 TYPE Change_Mesg_Attribute_Rec_Type IS RECORD
7 (
8 item_type VARCHAR2(8)
9 ,item_key VARCHAR2(240)
10 ,notification_id NUMBER
11 ,wf_msg_name VARCHAR2(30)
12 ,change_id NUMBER
13 ,change_line_id NUMBER
14 ,change_notice VARCHAR2(10)
15 ,organization_id NUMBER
16 ,organization_code VARCHAR2(3)
17 ,item_organization_id NUMBER
18 ,item_id NUMBER
19 ,item_name VARCHAR2(800)
20 ,item_revision_id NUMBER
21 ,item_revision VARCHAR2(3)
22 ,item_revision_label VARCHAR2(80)
23 ,change_management_type VARCHAR2(40)
24 ,change_name VARCHAR2(240)
25 ,description VARCHAR2(3000)
26 ,change_order_type VARCHAR2(10)
27 ,organization_name VARCHAR2(60)
28 ,eco_department VARCHAR2(60)
29 ,change_status VARCHAR2(80)
30 ,approval_status VARCHAR2(80)
31 ,priority VARCHAR2(50)
32 ,reason VARCHAR2(50)
33 ,assignee VARCHAR2(360)
34 ,assignee_company VARCHAR2(360)
35 ,line_sequence_number NUMBER
36 ,line_name VARCHAR2(240)
37 ,line_description VARCHAR2(5000)
38 ,line_status VARCHAR2(80)
39 ,line_assignee VARCHAR2(360)
40 ,line_assignee_company VARCHAR2(360)
41 ,action_id NUMBER
42 ,action_party_id NUMBER
43 ,action_party_name VARCHAR2(360)
44 ,action_party_company VARCHAR2(360)
45 ,action_desc VARCHAR2(5000)
46 ,route_id NUMBER
47 ,step_id NUMBER
48 ,step_seq_num NUMBER
49 ,required_date DATE
50 ,condition_type VARCHAR2(80)
51 ,step_instruction VARCHAR2(5000)
52 ,host_url VARCHAR2(480)
53 ,style_sheet VARCHAR2(100)
54 );
55
56
57
58 -- API name : GetMessageTextBody
59 -- Type : Private
60 -- Pre-reqs : None.
61 -- Function : Workflow PL/SQL CLOB Document API to get ntf text message body
62 -- Parameters : p_document_id IN VARCHAR2 Required
63 -- Format:
64 -- <wf item type>:<wf item key>:<&#NID>
65 PROCEDURE GetMessageTextBody
66 ( document_id IN VARCHAR2
67 , display_type IN VARCHAR2
68 , document IN OUT NOCOPY CLOB
69 , document_type IN OUT NOCOPY VARCHAR2
70 ) ;
71
72
73 -- API name : GetMessageHTMLBody
74 -- Type : Private
75 -- Pre-reqs : None.
76 -- Function : Workflow PL/SQL CLOB Document API to get ntf HTML message body
77 -- Parameters : p_document_id IN VARCHAR2 Required
78 -- Format:
79 -- <wf item type>:<wf item key>:<&#NID>
80 PROCEDURE GetMessageHTMLBody
81 ( document_id IN VARCHAR2
82 , display_type IN VARCHAR2
83 , document IN OUT NOCOPY CLOB
84 , document_type IN OUT NOCOPY VARCHAR2
85 ) ;
86
87
88
89 FUNCTION GetRunFuncURL
90 ( p_function_name IN VARCHAR2
91 , p_resp_appl_id IN NUMBER DEFAULT NULL
92 , p_resp_id IN NUMBER DEFAULT NULL
93 , p_security_group_id IN NUMBER DEFAULT NULL
94 , p_parameters IN VARCHAR2 DEFAULT NULL
95 ) RETURN VARCHAR2 ;
96
97
98 FUNCTION GetChangeRunFuncURL
99 ( p_change_id IN NUMBER)
100 RETURN VARCHAR2 ;
101
102 FUNCTION GetChangeSummaryRunFuncURL
103 ( p_change_id IN NUMBER)
104 RETURN VARCHAR2 ;
105
106
107 PROCEDURE GetNtfRecipient
108 ( p_notification_id IN NUMBER
109 , x_party_id OUT NOCOPY NUMBER
110 , x_party_name OUT NOCOPY VARCHAR2
111 , x_user_id OUT NOCOPY NUMBER
112 , x_user_name OUT NOCOPY VARCHAR2
113 ) ;
114
115
116 /*********************************************************************
117 * API Type : Public APIs
118 * Purpose : Those APIs are public
119 *********************************************************************/
120 -- None
121
122 END Eng_Workflow_Ntf_Util ;