APPS.POR_AME_REQ_WF_PVT dependencies on PO_DOCUMENT_TYPES

Line 48: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;

44: funcmode in varchar2,
45: resultout out NOCOPY varchar2) IS
46: l_progress VARCHAR2(3500) := '000';
47: l_document_id NUMBER;
48: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
49: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
50: l_next_approver_id NUMBER;
51: l_next_approver_user_name fnd_user.user_name%TYPE;
52: l_next_approver_disp_name wf_users.display_name%TYPE;

Line 49: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;

45: resultout out NOCOPY varchar2) IS
46: l_progress VARCHAR2(3500) := '000';
47: l_document_id NUMBER;
48: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
49: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
50: l_next_approver_id NUMBER;
51: l_next_approver_user_name fnd_user.user_name%TYPE;
52: l_next_approver_disp_name wf_users.display_name%TYPE;
53: l_orig_system wf_users.orig_system%TYPE := ame_util.perOrigSystem;

Line 64: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

60:
61: l_next_approver ame_util.approverRecord;
62: l_insertion_type VARCHAR2(30);
63: l_authority_type VARCHAR2(30);
64: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
65:
66: l_completeYNO varchar2(100);
67: l_position_has_valid_approvers varchar2(10);
68: l_need_to_get_next_approver boolean;

Line 255: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

251: l_next_approver_disp_name VARCHAR2(240);
252: l_orig_system VARCHAR2(48);
253: l_org_id number;
254: l_functional_currency VARCHAR2(30);
255: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
256:
257: n_varname Wf_Engine.NameTabTyp;
258: n_varval Wf_Engine.NumTabTyp;
259:

Line 658: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

654: p_response in varchar2 ) IS
655:
656: l_progress VARCHAR2(500) := '000';
657: l_document_id number;
658: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
659: l_current_approver ame_util.approverRecord2;
660: l_approver_posoition_id number;
661: l_approver_type varchar2(10);
662: l_error_code NUMBER;

Line 809: ameTransactionType po_document_types.ame_transaction_type%TYPE;

805: l_approver_group_id NUMBER;
806: l_req_header_id NUMBER;
807: l_process_out VARCHAR2(10);
808: approverList ame_util.approversTable2;
809: ameTransactionType po_document_types.ame_transaction_type%TYPE;
810: l_response_action VARCHAR2(20);
811: l_note VARCHAR2(4000);
812: l_person_id NUMBER;
813: l_orig_system VARCHAR2(3);