DBA Data[Home] [Help]

APPS.POS_WCAPPROVE_PVT dependencies on AME_UTIL

Line 995: l_next_approver ame_util.approversTable2;

991: l_next_approver_user_name VARCHAR2(100);
992: l_next_approver_disp_name VARCHAR2(240);
993: l_orig_system VARCHAR2(48);
994: l_completeYNO varchar2(100);
995: l_next_approver ame_util.approversTable2;
996: l_rule_id ame_util.idList;
997: l_po_preparer_id number;
998: l_respond_to_wc_url varchar2(1000);
999: l_default_approver varchar2(30);

Line 996: l_rule_id ame_util.idList;

992: l_next_approver_disp_name VARCHAR2(240);
993: l_orig_system VARCHAR2(48);
994: l_completeYNO varchar2(100);
995: l_next_approver ame_util.approversTable2;
996: l_rule_id ame_util.idList;
997: l_po_preparer_id number;
998: l_respond_to_wc_url varchar2(1000);
999: l_default_approver varchar2(30);
1000: BEGIN

Line 1349: 'Exception in ame_util.getNextApprove '

1345: when approver_exception then
1346: IF (g_asn_debug = 'Y') THEN
1347: debug_log(FND_LOG.LEVEL_UNEXPECTED,
1348: l_api_name,
1349: 'Exception in ame_util.getNextApprove '
1350: || l_progress);
1351: END IF;
1352: raise;
1353: when others then

Line 1925: l_current_approver ame_util.approverRecord2;

1921: l_forward_to_id NUMBER := NULL;
1922: l_transaction_type varchar2(100);
1923: l_shipment_header_id number;
1924: l_application_id number := '201'; -- use PO application id.
1925: l_current_approver ame_util.approverRecord2;
1926: l_approver_type varchar2(10);
1927: l_default_approver varchar2(30);
1928: l_next_approver_disp_name varchar2(100);
1929: l_reject_lines number;

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

2203:
2204: l_current_approver.orig_system_id := l_approver_id;
2205:
2206: if( l_response = 'APPROVE') then
2207: l_current_approver.approval_status := ame_util.approvedStatus;
2208: elsif( l_response = 'REJECT') then
2209: l_current_approver.approval_status := ame_util.rejectStatus;
2210: elsif( l_response = 'TIMEOUT') then
2211: l_current_approver.approval_status := ame_util.noResponseStatus;

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

2205:
2206: if( l_response = 'APPROVE') then
2207: l_current_approver.approval_status := ame_util.approvedStatus;
2208: elsif( l_response = 'REJECT') then
2209: l_current_approver.approval_status := ame_util.rejectStatus;
2210: elsif( l_response = 'TIMEOUT') then
2211: l_current_approver.approval_status := ame_util.noResponseStatus;
2212: else /* Can be approved/rejected from iSP UI */
2213: select count(*)

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

2207: l_current_approver.approval_status := ame_util.approvedStatus;
2208: elsif( l_response = 'REJECT') then
2209: l_current_approver.approval_status := ame_util.rejectStatus;
2210: elsif( l_response = 'TIMEOUT') then
2211: l_current_approver.approval_status := ame_util.noResponseStatus;
2212: else /* Can be approved/rejected from iSP UI */
2213: select count(*)
2214: into l_reject_lines
2215: from rcv_shipment_lines

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

2216: where shipment_header_id = l_shipment_header_id
2217: and approval_status = 'REJECTED';
2218:
2219: If (l_reject_lines > 0) then
2220: l_current_approver.approval_status := ame_util.rejectStatus;
2221: else
2222: l_current_approver.approval_status := ame_util.approvedStatus;
2223: end if;
2224:

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

2218:
2219: If (l_reject_lines > 0) then
2220: l_current_approver.approval_status := ame_util.rejectStatus;
2221: else
2222: l_current_approver.approval_status := ame_util.approvedStatus;
2223: end if;
2224:
2225:
2226: end if;