DBA Data[Home] [Help]

APPS.POR_AME_RCO_WF_PVT dependencies on AME_UTIL

Line 7: g_next_approvers ame_util.approversTable2;

3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
6:
7: g_next_approvers ame_util.approversTable2;
8:
9: FUNCTION position_has_valid_approvers( documentId NUMBER, documentType VARCHAR2 )RETURN VARCHAR2;
10: Function is_last_approver_record( documentId NUMBER, documentType VARCHAR2, approverRecord in ame_util.approverRecord2 ) RETURN VARCHAR2;
11:

Line 10: Function is_last_approver_record( documentId NUMBER, documentType VARCHAR2, approverRecord in ame_util.approverRecord2 ) RETURN VARCHAR2;

6:
7: g_next_approvers ame_util.approversTable2;
8:
9: FUNCTION position_has_valid_approvers( documentId NUMBER, documentType VARCHAR2 )RETURN VARCHAR2;
10: Function is_last_approver_record( documentId NUMBER, documentType VARCHAR2, approverRecord in ame_util.approverRecord2 ) RETURN VARCHAR2;
11:
12: PROCEDURE UpdateActionHistory(p_document_id NUMBER,
13: p_action VARCHAR2,
14: p_note VARCHAR2,

Line 60: l_next_approver ame_util.approverRecord;

56: l_doc_string varchar2(200);
57: l_preparer_user_name fnd_user.user_name%TYPE;
58: l_org_id number;
59:
60: l_next_approver ame_util.approverRecord;
61: l_insertion_type VARCHAR2(30);
62: l_authority_type VARCHAR2(30);
63: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
64: l_completeYNO varchar2(100);

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

99:
100: l_need_to_get_next_approver := FALSE;
101: BEGIN
102:
103: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanTrue;
104: ame_api2.getNextApprovers4( applicationIdIn=>applicationId,
105: transactionIdIn=>l_document_id,
106: transactionTypeIn=>l_transaction_type,
107: approvalProcessCompleteYNOut=>l_completeYNO,

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

464: po_wf_debug_pkg.insert_debug(itemtype,itemkey,l_progress);
465: END IF;
466:
467: t_varname(22) := 'RCO_AME_IS_FYI_APPROVER';
468: if (g_next_approvers(l_approver_index).approver_category = ame_util.fyiApproverCategory) then
469: t_varval(22) :='Y';
470: else
471: t_varval(22) :='N';
472: l_start_block_activity := 'Y';

Line 575: l_current_approver ame_util.approverRecord2;

571:
572: l_progress VARCHAR2(500) := '000';
573: l_document_id number;
574: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
575: l_current_approver ame_util.approverRecord2;
576: l_approver_posoition_id number;
577: l_approver_type varchar2(10);
578:
579: begin

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

620: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
621: END IF;
622:
623: if( p_response = 'APPROVE') then
624: l_current_approver.approval_status := ame_util.approvedStatus;
625: elsif( p_response = 'REJECT') then
626: l_current_approver.approval_status := ame_util.rejectStatus;
627: elsif( p_response = 'TIMEOUT') then
628: l_current_approver.approval_status := ame_util.noResponseStatus;

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

622:
623: if( p_response = 'APPROVE') then
624: l_current_approver.approval_status := ame_util.approvedStatus;
625: elsif( p_response = 'REJECT') then
626: l_current_approver.approval_status := ame_util.rejectStatus;
627: elsif( p_response = 'TIMEOUT') then
628: l_current_approver.approval_status := ame_util.noResponseStatus;
629: end if;
630:

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

624: l_current_approver.approval_status := ame_util.approvedStatus;
625: elsif( p_response = 'REJECT') then
626: l_current_approver.approval_status := ame_util.rejectStatus;
627: elsif( p_response = 'TIMEOUT') then
628: l_current_approver.approval_status := ame_util.noResponseStatus;
629: end if;
630:
631: l_progress := 'Process_Response_Internal: 004 -- p_response :' || p_response ;
632: IF (g_po_wf_debug = 'Y') THEN

Line 1712: g_next_approvers(l_approver_index).approval_status := ame_util.noResponseStatus;

1708: return 'N';
1709: else
1710:
1711: /*
1712: g_next_approvers(l_approver_index).approval_status := ame_util.noResponseStatus;
1713: -- Update the Approval status with the response from the approver.
1714: ame_api2.updateApprovalStatus( applicationIdIn =>applicationId,
1715: transactionIdIn =>documentId,
1716: transactionTypeIn =>documentType,

Line 1769: Function is_last_approver_record( documentId NUMBER, documentType VARCHAR2, approverRecord in ame_util.approverRecord2 ) RETURN VARCHAR2 is

1765: --Testing:
1766: --
1767: --End of Comments
1768: -------------------------------------------------------------------------------
1769: Function is_last_approver_record( documentId NUMBER, documentType VARCHAR2, approverRecord in ame_util.approverRecord2 ) RETURN VARCHAR2 is
1770:
1771: l_is_last_approver_record VARCHAR2(1);
1772: l_total_approver_count NUMBER;
1773: l_current_approver_index NUMBER;

Line 1774: tmpApproverList ame_util.approversTable2;

1770:
1771: l_is_last_approver_record VARCHAR2(1);
1772: l_total_approver_count NUMBER;
1773: l_current_approver_index NUMBER;
1774: tmpApproverList ame_util.approversTable2;
1775: l_process_out VARCHAR2(10);
1776:
1777: BEGIN
1778: