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.ASO_PA_APR_WF_PVT dependencies on AME_UTIL

Line 9: g_next_approvers ame_util.approversTable2;

5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asovwpab.pls';
6:
7: g_user_id NUMBER:= FND_GLOBAL.USER_ID;
8:
9: g_next_approvers ame_util.approversTable2;
10:
11:
12: PROCEDURE start_aso_approvals (
13: P_Object_approval_id IN NUMBER,

Line 275: l_ame_exception ame_util.longestStringType:=null;

271:
272: l_completeYNO VARCHAR2(1);
273: -- l_position_has_valid_approvers VARCHAR2(10);
274: l_need_to_get_next_approver BOOLEAN;
275: l_ame_exception ame_util.longestStringType:=null;
276: l_api_name VARCHAR2(500) := 'get_next_approvers';
277:
278: l_approval_id number;
279: l_object_id NUMBER;

Line 282: x_rules_list_id ame_util.idList;

278: l_approval_id number;
279: l_object_id NUMBER;
280: l_object_type VARCHAR2 (240);
281: l_application_id NUMBER;
282: x_rules_list_id ame_util.idList;
283:
284: CURSOR get_application_id (
285: c_object_approval_id NUMBER
286: ) IS

Line 341: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanTrue;

337: insertruledetails(approvalid => l_approval_id,
338: p_rule_list_ids=> x_rules_list_id);
339: --pp_debug('after insert rules call');
340:
341: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanTrue;
342: ame_api2.getNextApprovers4( applicationIdIn=>l_application_id,
343: transactionIdIn=>l_object_id,
344: transactionTypeIn=>l_object_type,
345: flagapproversasnotifiedin => ame_util.booleantrue,

Line 345: flagapproversasnotifiedin => ame_util.booleantrue,

341: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanTrue;
342: ame_api2.getNextApprovers4( applicationIdIn=>l_application_id,
343: transactionIdIn=>l_object_id,
344: transactionTypeIn=>l_object_type,
345: flagapproversasnotifiedin => ame_util.booleantrue,
346: approvalProcessCompleteYNOut=>l_completeYNO,
347: nextApproversOut=>g_next_approvers
348: );
349:

Line 733: if (g_next_approvers(l_approver_index).orig_system = ame_util.perOrigSystem) then

729:
730: /* Need to test the following how to get the username of approver */
731: /* l_forward_user_name, l_forward_displayname */
732:
733: if (g_next_approvers(l_approver_index).orig_system = ame_util.perOrigSystem) then
734: l_next_approver_id := g_next_approvers(l_approver_index).orig_system_id;
735: l_next_fnd_usr_id:=null;
736: elsif (g_next_approvers(l_approver_index).orig_system = ame_util.fndUserOrigSystem) then
737: l_next_fnd_usr_id:= g_next_approvers(l_approver_index).orig_system_id;

Line 736: elsif (g_next_approvers(l_approver_index).orig_system = ame_util.fndUserOrigSystem) then

732:
733: if (g_next_approvers(l_approver_index).orig_system = ame_util.perOrigSystem) then
734: l_next_approver_id := g_next_approvers(l_approver_index).orig_system_id;
735: l_next_fnd_usr_id:=null;
736: elsif (g_next_approvers(l_approver_index).orig_system = ame_util.fndUserOrigSystem) then
737: l_next_fnd_usr_id:= g_next_approvers(l_approver_index).orig_system_id;
738: l_next_approver_id:=null;
739: WF_DIRECTORY.GetUserName(ame_util.fndUserOrigSystem, l_next_fnd_usr_id, l_next_approver_user_name, l_next_approver_disp_name);
740: elsif (g_next_approvers(l_approver_index).orig_system = ame_util.posOrigSystem) then

Line 739: WF_DIRECTORY.GetUserName(ame_util.fndUserOrigSystem, l_next_fnd_usr_id, l_next_approver_user_name, l_next_approver_disp_name);

735: l_next_fnd_usr_id:=null;
736: elsif (g_next_approvers(l_approver_index).orig_system = ame_util.fndUserOrigSystem) then
737: l_next_fnd_usr_id:= g_next_approvers(l_approver_index).orig_system_id;
738: l_next_approver_id:=null;
739: WF_DIRECTORY.GetUserName(ame_util.fndUserOrigSystem, l_next_fnd_usr_id, l_next_approver_user_name, l_next_approver_disp_name);
740: elsif (g_next_approvers(l_approver_index).orig_system = ame_util.posOrigSystem) then
741: l_next_approver_id := g_next_approvers(l_approver_index).orig_system_id;
742: l_next_fnd_usr_id:=null;
743:

Line 740: elsif (g_next_approvers(l_approver_index).orig_system = ame_util.posOrigSystem) then

736: elsif (g_next_approvers(l_approver_index).orig_system = ame_util.fndUserOrigSystem) then
737: l_next_fnd_usr_id:= g_next_approvers(l_approver_index).orig_system_id;
738: l_next_approver_id:=null;
739: WF_DIRECTORY.GetUserName(ame_util.fndUserOrigSystem, l_next_fnd_usr_id, l_next_approver_user_name, l_next_approver_disp_name);
740: elsif (g_next_approvers(l_approver_index).orig_system = ame_util.posOrigSystem) then
741: l_next_approver_id := g_next_approvers(l_approver_index).orig_system_id;
742: l_next_fnd_usr_id:=null;
743:
744: end if;

Line 747: IF (g_next_approvers(l_approver_index).orig_system = ame_util.perOrigSystem) or (g_next_approvers(l_approver_index).orig_system = ame_util.posOrigSystem) then

743:
744: end if;
745:
746:
747: IF (g_next_approvers(l_approver_index).orig_system = ame_util.perOrigSystem) or (g_next_approvers(l_approver_index).orig_system = ame_util.posOrigSystem) then
748: l_forward_user_name := g_next_approvers(l_approver_index).name;
749: l_forward_displayname:= g_next_approvers(l_approver_index).display_name;
750:
751: ELSE

Line 826: if (g_next_approvers(l_approver_index).approver_category = ame_util.fyiApproverCategory) then

822: );
823:
824:
825:
826: if (g_next_approvers(l_approver_index).approver_category = ame_util.fyiApproverCategory) then
827: l_has_fyi_app := 'Y';
828: l_start_block_activity := 'N';
829: wf_engine.setitemattrtext (
830: itemtype => itemtype,

Line 1396: l_current_approver ame_util.approverRecord2;

1392: PROCEDURE process_response_ame(itemtype in varchar2,
1393: itemkey in varchar2,
1394: p_response in varchar2) IS
1395:
1396: l_current_approver ame_util.approverRecord2;
1397: l_approval_det_id number;
1398: l_obj_approval_id number;
1399: l_object_id NUMBER;
1400: l_object_type VARCHAR2 (240);

Line 1419: l_current_approver.approval_status := ame_util.approvedStatus;

1415:
1416: begin
1417:
1418: if( p_response = 'APPROVE') then
1419: l_current_approver.approval_status := ame_util.approvedStatus;
1420: elsif( p_response = 'REJECT') then
1421: l_current_approver.approval_status := ame_util.rejectStatus;
1422: elsif( p_response = 'TIMEOUT') then
1423: l_current_approver.approval_status := ame_util.noResponseStatus;

Line 1421: l_current_approver.approval_status := ame_util.rejectStatus;

1417:
1418: if( p_response = 'APPROVE') then
1419: l_current_approver.approval_status := ame_util.approvedStatus;
1420: elsif( p_response = 'REJECT') then
1421: l_current_approver.approval_status := ame_util.rejectStatus;
1422: elsif( p_response = 'TIMEOUT') then
1423: l_current_approver.approval_status := ame_util.noResponseStatus;
1424: end if;
1425:

Line 1423: l_current_approver.approval_status := ame_util.noResponseStatus;

1419: l_current_approver.approval_status := ame_util.approvedStatus;
1420: elsif( p_response = 'REJECT') then
1421: l_current_approver.approval_status := ame_util.rejectStatus;
1422: elsif( p_response = 'TIMEOUT') then
1423: l_current_approver.approval_status := ame_util.noResponseStatus;
1424: end if;
1425:
1426: l_approval_det_id := wf_engine.getitemattrnumber (
1427: itemtype,

Line 1515: approverlist ame_util.approverstable2;

1511: l_child_approver_empid NUMBER;
1512: l_child_approver_groupid NUMBER;
1513: l_header_id NUMBER;
1514: l_process_out VARCHAR2 (10);
1515: approverlist ame_util.approverstable2;
1516: ametransactiontype po_document_types.ame_transaction_type%TYPE;
1517: l_response_action VARCHAR2 (20);
1518: l_note VARCHAR2 (4000);
1519: l_person_id NUMBER;

Line 1545: tempOrigSystem ame_util.stringType;

1541: l_current_person_id NUMBER;
1542: l_current_appr_group_id NUMBER;
1543: l_abort NUMBER;
1544: l_current_username wf_users.name%TYPE;
1545: tempOrigSystem ame_util.stringType;
1546: l_approval_det_id number;
1547: l_child_username wf_users.name%TYPE;
1548: l_fnd_usr_id number;
1549:

Line 1626: IF ( approverlist (i).approval_status = ame_util.beatbyfirstresponderstatus

1622: --pp_debug('In beat by first resp approval_status'||approverlist (i).approval_status);
1623: --pp_debug('In beat by first resp api_insertion'||approverlist (i).api_insertion);
1624: --pp_debug('In beat by first resp group_or_chain_id'||approverlist (i).group_or_chain_id);
1625:
1626: IF ( approverlist (i).approval_status = ame_util.beatbyfirstresponderstatus
1627: AND approverlist (i).api_insertion = ame_util.oamgenerated
1628: AND approverlist (i).group_or_chain_id =l_current_appr_group_id)
1629: THEN
1630: -- pp_debug('In beat by first resp group_or_chain_id'||approverlist (i).group_or_chain_id);

Line 1627: AND approverlist (i).api_insertion = ame_util.oamgenerated

1623: --pp_debug('In beat by first resp api_insertion'||approverlist (i).api_insertion);
1624: --pp_debug('In beat by first resp group_or_chain_id'||approverlist (i).group_or_chain_id);
1625:
1626: IF ( approverlist (i).approval_status = ame_util.beatbyfirstresponderstatus
1627: AND approverlist (i).api_insertion = ame_util.oamgenerated
1628: AND approverlist (i).group_or_chain_id =l_current_appr_group_id)
1629: THEN
1630: -- pp_debug('In beat by first resp group_or_chain_id'||approverlist (i).group_or_chain_id);
1631: l_orig_system := approverlist (i).orig_system;

Line 1634: IF (l_orig_system = ame_util.perorigsystem)

1630: -- pp_debug('In beat by first resp group_or_chain_id'||approverlist (i).group_or_chain_id);
1631: l_orig_system := approverlist (i).orig_system;
1632: l_orig_system_id := approverlist (i).orig_system_id;
1633:
1634: IF (l_orig_system = ame_util.perorigsystem)
1635: THEN
1636: -- Employee Supervisor Record.
1637: l_person_id := l_orig_system_id;
1638:

Line 1639: ELSIF (l_orig_system = ame_util.posorigsystem)

1635: THEN
1636: -- Employee Supervisor Record.
1637: l_person_id := l_orig_system_id;
1638:
1639: ELSIF (l_orig_system = ame_util.posorigsystem)
1640: THEN
1641: l_person_id := l_orig_system_id;
1642:
1643: ELSIF (l_orig_system = ame_util.fnduserorigsystem)

Line 1643: ELSIF (l_orig_system = ame_util.fnduserorigsystem)

1639: ELSIF (l_orig_system = ame_util.posorigsystem)
1640: THEN
1641: l_person_id := l_orig_system_id;
1642:
1643: ELSIF (l_orig_system = ame_util.fnduserorigsystem)
1644: THEN
1645: -- FND User Record.
1646: l_fnd_usr_id:=l_orig_system_id;
1647:

Line 3399: l_ame_exception ame_util.longestStringType:=null;

3395: actid IN NUMBER,
3396: funcmode IN VARCHAR2,
3397: resultout OUT NOCOPY VARCHAR2)
3398: IS
3399: l_ame_exception ame_util.longestStringType:=null;
3400: l_api_name VARCHAR2(500) := 'is_ame_exception';
3401:
3402: BEGIN
3403:

Line 3522: procedure insertruledetails(approvalid number, p_rule_list_ids ame_util.idList) IS

3518: );
3519: commit;
3520: end insertapprovershistory;
3521:
3522: procedure insertruledetails(approvalid number, p_rule_list_ids ame_util.idList) IS
3523: pragma AUTONOMOUS_TRANSACTION;
3524:
3525: p_rule_id number;
3526: