DBA Data[Home] [Help]

APPS.POR_AME_RCO_WF_PVT dependencies on PO_DOCUMENT_TYPES

Line 47: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;

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

Line 48: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;

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

Line 63: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

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);
65: l_position_has_valid_approvers varchar2(10);
66: l_need_to_get_next_approver boolean;
67: BEGIN

Line 238: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

234: l_next_approver_disp_name VARCHAR2(240);
235: l_orig_system VARCHAR2(48);
236: l_org_id number;
237: l_functional_currency VARCHAR2(30);
238: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
239:
240: n_varname Wf_Engine.NameTabTyp;
241: n_varval Wf_Engine.NumTabTyp;
242:

Line 574: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

570: p_response in varchar2 ) IS
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: