eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:

Line 158: all_approvers ame_util.approversTable2;

154: actid in number,
155: funcmode in varchar2,
156: resultout out nocopy varchar2)
157: is
158: all_approvers ame_util.approversTable2;
159: next_approver ame_util.approversTable2;
160: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
161: l_apprvl_process_complete varchar2(1000);
162: l_proc varchar2(72) := g_package||'check_approvers_exist';

Line 159: next_approver ame_util.approversTable2;

155: funcmode in varchar2,
156: resultout out nocopy varchar2)
157: is
158: all_approvers ame_util.approversTable2;
159: next_approver ame_util.approversTable2;
160: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
161: l_apprvl_process_complete varchar2(1000);
162: l_proc varchar2(72) := g_package||'check_approvers_exist';
163: l_flagApproversAsNotified varchar2(10);

Line 167: l_wf_admin ame_util.approverRecord2;

163: l_flagApproversAsNotified varchar2(10);
164: l_role_name varchar2(240);
165: l_role_display_name varchar2(240);
166:
167: l_wf_admin ame_util.approverRecord2;
168: l_admin_name varchar2(240);
169: l_admin_display_name varchar2(240);
170: begin
171: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 190: resultout := ame_util.booleanTrue;

186: as expected. We are not supposed to reject any Workflow in the absense of
187: approver.*/
188:
189: hr_utility.set_location(l_proc, 20);
190: resultout := ame_util.booleanTrue;
191: begin
192: ame_api2.getNextApprovers4(
193: applicationIdIn => 801,
194: transactionTypeIn => 'PAY_ASSIGNMENT_COSTING',

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

194: transactionTypeIn => 'PAY_ASSIGNMENT_COSTING',
195: transactionIdIn => l_transaction_id,
196: approvalProcessCompleteYNOut => l_apprvl_process_complete,
197: nextApproversOut => g_approver);
198: if (l_apprvl_process_complete = ame_util.booleanTrue) then
199: resultout := 'F';
200: else
201: resultout := 'T';
202: end if;

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

207: when OTHERS then
208: wf_engine.setItemAttrText(itemtype, itemkey,'AME_EXCEPTION',SQLERRM(SQLCODE));
209: resultout:='F';
210: end;
211: if resultout <> 'F' and l_apprvl_process_complete <> ame_util.booleanTrue then
212: /*First clear all approvers, then get the approver again. This is to by-pass
213: NO_DATA_FOUND exception. This situation occurs when there is no approver
214: and resume the workflow after setting the approver.*/
215: ame_api2.clearAllApprovals(

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

222: transactionTypeIn => 'PAY_ASSIGNMENT_COSTING',
223: transactionIdIn => l_transaction_id,
224: approvalProcessCompleteYNOut => l_apprvl_process_complete,
225: nextApproversOut => g_approver);
226: if (l_apprvl_process_complete <> ame_util.booleanTrue) then
227: wf_engine.setItemAttrText(itemtype, itemkey,'APPROVER_LOGIN_NAME',g_approver(1).name);
228: wf_directory.GetRoleName(p_orig_system => NVL(g_approver(1).orig_system,'PER')
229: ,p_orig_system_id => g_approver(1).orig_system_id
230: ,p_name => l_role_name

Line 252: l_current_approver ame_util.approversTable2 := g_approver;

248: actid in number,
249: funcmode in varchar2,
250: resultout out nocopy varchar2) is
251:
252: l_current_approver ame_util.approversTable2 := g_approver;
253: l_next_approver ame_util.approversTable2;
254:
255: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
256: l_apprvl_process_complete varchar2(1000);

Line 253: l_next_approver ame_util.approversTable2;

249: funcmode in varchar2,
250: resultout out nocopy varchar2) is
251:
252: l_current_approver ame_util.approversTable2 := g_approver;
253: l_next_approver ame_util.approversTable2;
254:
255: l_transaction_id HR_API_TRANSACTIONS.TRANSACTION_ID%TYPE;
256: l_apprvl_process_complete varchar2(1000);
257: l_proc varchar2(72);

Line 280: approvalStatusIn => ame_util.approvedStatus,

276: ame_api2.updateApprovalStatus2(
277: applicationIdIn =>801,
278: transactionTypeIn =>'PAY_ASSIGNMENT_COSTING',
279: transactionIdIn =>l_transaction_id,
280: approvalStatusIn => ame_util.approvedStatus,
281: approverNameIn => wf_engine.getItemAttrText(itemtype, itemkey,'APPROVER_LOGIN_NAME'),
282: updateItemIn => true);
283:
284: /*Now get the next approver.*/

Line 299: if l_apprvl_process_complete = ame_util.booleanFalse then

295: If there are no approvers then we need to save the data. Once the resultout
296: is set to 'F' workflow take care of saving the data by calling underlaying
297: APIs*/
298: hr_utility.set_location(l_proc, 40);
299: if l_apprvl_process_complete = ame_util.booleanFalse then
300: /*Set the previous approver attributes.*/
301: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',
302: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));
303: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',

Line 347: l_wf_admin ame_util.approverRecord2;

343: l_proc varchar2(72) ;
344: --
345: l_user_key varchar2(240) := p_Item_Key;
346: --
347: l_wf_admin ame_util.approverRecord2;
348: l_admin_name varchar2(240);
349: l_admin_display_name varchar2(240);
350:
351: CURSOR csr_person_name is