APPS.PAY_ASSG_COST_WF dependencies on AME_UTIL

Line 8: g_approver ame_util.approversTable2;

4: -- Package Variables
5: --
6: g_package varchar2(33) := ' PAY_ASSG_COST_WF.';
7: g_debug boolean := hr_utility.debug_enabled;
8: g_approver ame_util.approversTable2;
9: /*Used to get the transaction id pertaining to the specified
10: item type and item key. If the transaction id does not exists
11: then it will create starting a transaction.*/
12: FUNCTION GET_TRANSACTION_ID(

Line 65: all_approvers ame_util.approversTable2;

61: actid in number,
62: funcmode in varchar2,
63: resultout out nocopy varchar2)
64: is
65: all_approvers ame_util.approversTable2;
66: next_approver ame_util.approversTable2;
67: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
68: l_apprvl_process_complete varchar2(1000);
69: l_proc varchar2(72) := g_package||'check_approvers_exist';

Line 66: next_approver ame_util.approversTable2;

62: funcmode in varchar2,
63: resultout out nocopy varchar2)
64: is
65: all_approvers ame_util.approversTable2;
66: next_approver ame_util.approversTable2;
67: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
68: l_apprvl_process_complete varchar2(1000);
69: l_proc varchar2(72) := g_package||'check_approvers_exist';
70: l_flagApproversAsNotified varchar2(10);

Line 74: l_wf_admin ame_util.approverRecord2;

70: l_flagApproversAsNotified varchar2(10);
71: l_role_name varchar2(240);
72: l_role_display_name varchar2(240);
73:
74: l_wf_admin ame_util.approverRecord2;
75: l_admin_name varchar2(240);
76: l_admin_display_name varchar2(240);
77: begin
78: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 94: resultout := ame_util.booleanTrue;

90: as expected. We are not supposed to reject any Workflow in the absense of
91: approver.*/
92:
93: hr_utility.set_location(l_proc, 20);
94: resultout := ame_util.booleanTrue;
95: begin
96: ame_api2.getNextApprovers4(
97: applicationIdIn => 801,
98: transactionTypeIn => 'PAY_ASSIGNMENT_COSTING',

Line 102: if (l_apprvl_process_complete = ame_util.booleanTrue) then

98: transactionTypeIn => 'PAY_ASSIGNMENT_COSTING',
99: transactionIdIn => l_transaction_id,
100: approvalProcessCompleteYNOut => l_apprvl_process_complete,
101: nextApproversOut => g_approver);
102: if (l_apprvl_process_complete = ame_util.booleanTrue) then
103: resultout := 'F';
104: else
105: resultout := 'T';
106: end if;

Line 115: if resultout <> 'F' and l_apprvl_process_complete <> ame_util.booleanTrue then

111: when OTHERS then
112: wf_engine.setItemAttrText(itemtype, itemkey,'AME_EXCEPTION',SQLERRM(SQLCODE));
113: resultout:='F';
114: end;
115: if resultout <> 'F' and l_apprvl_process_complete <> ame_util.booleanTrue then
116: /*First clear all approvers, then get the approver again. This is to by-pass
117: NO_DATA_FOUND exception. This situation occurs when there is no approver
118: and resume the workflow after setting the approver.*/
119: ame_api2.clearAllApprovals(

Line 130: if (l_apprvl_process_complete <> ame_util.booleanTrue) then

126: transactionTypeIn => 'PAY_ASSIGNMENT_COSTING',
127: transactionIdIn => l_transaction_id,
128: approvalProcessCompleteYNOut => l_apprvl_process_complete,
129: nextApproversOut => g_approver);
130: if (l_apprvl_process_complete <> ame_util.booleanTrue) then
131: wf_engine.setItemAttrText(itemtype, itemkey,'APPROVER_LOGIN_NAME',g_approver(1).name);
132: wf_directory.GetRoleName(p_orig_system => NVL(g_approver(1).orig_system,'PER')
133: ,p_orig_system_id => g_approver(1).orig_system_id
134: ,p_name => l_role_name

Line 156: l_current_approver ame_util.approversTable2 := g_approver;

152: actid in number,
153: funcmode in varchar2,
154: resultout out nocopy varchar2) is
155:
156: l_current_approver ame_util.approversTable2 := g_approver;
157: l_next_approver ame_util.approversTable2;
158:
159: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
160: l_apprvl_process_complete varchar2(1000);

Line 157: l_next_approver ame_util.approversTable2;

153: funcmode in varchar2,
154: resultout out nocopy varchar2) is
155:
156: l_current_approver ame_util.approversTable2 := g_approver;
157: l_next_approver ame_util.approversTable2;
158:
159: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
160: l_apprvl_process_complete varchar2(1000);
161: l_proc varchar2(72);

Line 184: approvalStatusIn => ame_util.approvedStatus,

180: ame_api2.updateApprovalStatus2(
181: applicationIdIn =>801,
182: transactionTypeIn =>'PAY_ASSIGNMENT_COSTING',
183: transactionIdIn =>l_transaction_id,
184: approvalStatusIn => ame_util.approvedStatus,
185: approverNameIn => wf_engine.getItemAttrText(itemtype, itemkey,'APPROVER_LOGIN_NAME'),
186: updateItemIn => true);
187:
188: /*Now get the next approver.*/

Line 203: if l_apprvl_process_complete = ame_util.booleanFalse then

199: If there are no approvers then we need to save the data. Once the resultout
200: is set to 'F' workflow take care of saving the data by calling underlaying
201: APIs*/
202: hr_utility.set_location(l_proc, 40);
203: if l_apprvl_process_complete = ame_util.booleanFalse then
204: /*Set the previous approver attributes.*/
205: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',
206: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));
207: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',

Line 250: l_wf_admin ame_util.approverRecord2;

246: l_proc varchar2(72) ;
247: --
248: l_user_key varchar2(240) := p_Item_Key;
249: --
250: l_wf_admin ame_util.approverRecord2;
251: l_admin_name varchar2(240);
252: l_admin_display_name varchar2(240);
253:
254: CURSOR csr_person_name is