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 469: if (g_next_approvers(l_approver_index).approver_category = ame_util.fyiApproverCategory) then

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

Line 576: l_current_approver ame_util.approverRecord2;

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

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

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

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

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

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

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

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

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

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

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

Line 1776: tmpApproverList ame_util.approversTable2;

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