1 PACKAGE HR_APPROVAL_SS AUTHID CURRENT_USER AS
2 /* $Header: hraprvlss.pkh 120.8 2012/01/06 03:58:19 ckondapi ship $ */
3
4
5 procedure getNextApproverRole(p_item_type in varchar2,
6 p_item_key in varchar2,
7 p_act_id in number,
8 funmode in varchar2,
9 result out nocopy varchar2 );
10 procedure isFinalApprover( p_item_type in varchar2,
11 p_item_key in varchar2,
12 p_act_id in number,
13 funmode in varchar2,
14 result out nocopy varchar2 );
15
16 procedure updateApproveStatus( p_item_type in varchar2,
17 p_item_key in varchar2,
18 p_act_id in number,
19 funmode in varchar2,
20 result out nocopy varchar2 );
21
22 procedure approver_category( p_item_type in varchar2,
23 p_item_key in varchar2,
24 p_act_id in number,
25 funmode in varchar2,
26 result out nocopy varchar2 );
27
28 procedure flagApproversAsNotified( p_item_type in varchar2,
29 p_item_key in varchar2,
30 p_act_id in number,
31 funmode in varchar2,
32 result out nocopy varchar2 );
33 procedure updateNoResponseStatus( p_item_type in varchar2,
34 p_item_key in varchar2,
35 p_act_id in number,
36 funmode in varchar2,
37 result out nocopy varchar2 );
38 procedure setRespondedUserContext( p_item_type in varchar2,
39 p_item_key in varchar2,
40 p_act_id in number,
41 funmode in varchar2,
42 result out nocopy varchar2 );
43 procedure submit_for_approval( p_item_type in varchar2,
44 p_item_key in varchar2,
45 p_act_id in number,
46 funmode in varchar2,
47 result out nocopy varchar2 );
48
49 procedure setSFLResponseContext( p_item_type in varchar2,
50 p_item_key in varchar2,
51 p_act_id in number,
52 funmode in varchar2,
53 result out nocopy varchar2 );
54 procedure setRFCResponseContext( p_item_type in varchar2,
55 p_item_key in varchar2,
56 p_act_id in number,
57 funmode in varchar2,
58 result out nocopy varchar2 );
59
60 procedure setApproverResponseContext( p_item_type in varchar2,
61 p_item_key in varchar2,
62 p_act_id in number,
63 funmode in varchar2,
64 result out nocopy varchar2 );
65 procedure processRFC( p_item_type in varchar2,
66 p_item_key in varchar2,
67 p_act_id in number,
68 funmode in varchar2,
69 result out nocopy varchar2 );
70 function getRoleDisplayName(p_user_name in varchar2,
71 p_orig_system in varchar2,
72 p_orig_system_id in number) return varchar2;
73 function isApproverEditAllowed(p_transaction_id number default null,
74 p_user_name in varchar2,
75 p_orig_system in varchar2,
76 p_orig_system_id in number) return varchar2;
77 function getuserOrigSystem(p_user_name in fnd_user.user_name%type
78 ,p_notification_id in number default null)
79 return wf_roles.parent_orig_system%type;
80
81 function getUserOrigSystemId(p_user_name in fnd_user.user_name%type
82 ,p_notification_id in number default null)
83 return wf_roles.orig_system_id%type;
84 procedure handleRFCAction(p_approval_notification_id in wf_notifications.notification_id%type,
85 p_transaction_id in hr_api_transactions.transaction_id%type,
86 p_item_type in wf_items.item_type%type,
87 p_item_key in wf_items.item_key%type,
88 p_rfcRoleName in wf_roles.name%type,
89 p_rfcUserOrigSystem in wf_roles.orig_system%type,
90 p_rfcUserOrigSystemId in wf_roles.orig_system_id%type,
91 p_rfc_comments in varchar2,
92 p_approverIndex in number
93 );
94 procedure handleRFCAction(p_approval_notification_id in wf_notifications.notification_id%type
95 );
96 procedure reInitPerformerRoles(p_notification_id in wf_notifications.notification_id%type,
97 p_transaction_id in hr_api_transactions.transaction_id%type,
98 p_item_type in wf_items.item_type%type,
99 p_item_key in wf_items.item_key%type);
100
101 procedure approvals_block
102 (itemtype in varchar2
103 ,itemkey in varchar2
104 ,actid in number
105 ,funmode in varchar2
106 ,result in out nocopy varchar2);
107
108 procedure create_item_attrib_if_notexist(itemtype in varchar2,
109 itemkey in varchar2,
110 aname in varchar2,
111 text_value in varchar2,
112 number_value in number,
113 date_value in date );
114
115 procedure startGenericApprovalProcess(p_transaction_id in number
116 ,p_item_key in out nocopy wf_items.item_key%type
117 ,p_wf_ntf_sub_fnd_msg in fnd_new_messages.message_name%type
118 ,p_relaunch_function hr_api_transactions.relaunch_function%type
119 ,p_additional_wf_attributes in HR_WF_ATTR_TABLE
120 ,p_status out nocopy varchar2
121 ,p_error_message out nocopy varchar2
122 ,p_errstack out nocopy varchar2
123 );
124
125
126 procedure processApprovalSubmit(p_transaction_id in number,
127 p_approval_comments in varchar2);
128
129 function getinitApprovalBlockId(p_transaction_id in number) return number;
130
131 function getOAFPageActId(p_item_type in wf_items.item_type%type,
132 p_item_key in wf_items.item_key%type) return number;
133
134 procedure resetWfPageFlowState(p_transaction_id in number);
135
136 procedure checktransactionState(p_transaction_id IN NUMBER);
137
138 function getApproverNtfId(p_transaction_id in number) return number;
139
140 procedure handleApprovalErrors(p_item_type in wf_items.item_type%type,
141 p_item_key in wf_items.item_key%type,
142 error_message_text in varchar2);
143
144 procedure updateRejectStatus( p_item_type in varchar2,
145 p_item_key in varchar2,
146 p_act_id in number,
147 funmode in varchar2,
148 result out nocopy varchar2);
149
150 function getToString(p_item_key in varchar2)
151 return varchar2;
152
153 END HR_APPROVAL_SS;
154