eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POR_AME_APPROVAL_LIST_WF1S dependencies on PO_DOCUMENT_TYPES

Line 86: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

82: resultout out NOCOPY varchar2 )
83: is
84:
85: l_progress VARCHAR2(100) := '000';
86: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
87: l_document_id NUMBER;
88: l_interface_source VARCHAR2(30);
89:
90: l_tmp_approver ame_util.approverRecord2;

Line 238: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;

234: actid in number,
235: funcmode in varchar2,
236: resultout out NOCOPY varchar2) IS
237: l_progress VARCHAR2(100) := '000';
238: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
239: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
240: l_is_ame_approval boolean;
241: l_doc_string varchar2(200);
242: l_preparer_user_name varchar2(100);

Line 239: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;

235: funcmode in varchar2,
236: resultout out NOCOPY varchar2) IS
237: l_progress VARCHAR2(100) := '000';
238: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
239: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
240: l_is_ame_approval boolean;
241: l_doc_string varchar2(200);
242: l_preparer_user_name varchar2(100);
243: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

Line 243: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

239: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
240: l_is_ame_approval boolean;
241: l_doc_string varchar2(200);
242: l_preparer_user_name varchar2(100);
243: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
244:
245: begin
246:
247: IF (funcmode = 'RUN') THEN

Line 264: FROM po_document_types

260:
261:
262: SELECT ame_transaction_type
263: INTO l_transaction_type
264: FROM po_document_types
265: WHERE document_type_code = l_document_type
266: and document_subtype = l_document_subtype;
267:
268: if (l_transaction_type is not null) then

Line 339: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

335: l_progress VARCHAR2(100) := '000';
336: l_is_ame_approval boolean;
337: l_doc_string varchar2(200);
338: l_preparer_user_name varchar2(100);
339: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
340:
341: begin
342:
343: IF (funcmode = 'RUN') THEN

Line 353: FROM po_document_types

349:
350: begin
351: SELECT ame_transaction_type
352: INTO l_transaction_type
353: FROM po_document_types
354: WHERE document_type_code = 'CHANGE_REQUEST'
355: and document_subtype = 'REQUISITION' ;
356: exception
357: when others then

Line 437: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;

433: funcmode in varchar2,
434: resultout out NOCOPY varchar2) IS
435: l_progress VARCHAR2(100) := '000';
436: l_document_id NUMBER;
437: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
438: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
439: l_next_approver_id NUMBER;
440: l_next_approver_user_name fnd_user.user_name%TYPE;
441: l_next_approver_disp_name wf_users.display_name%TYPE;

Line 438: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;

434: resultout out NOCOPY varchar2) IS
435: l_progress VARCHAR2(100) := '000';
436: l_document_id NUMBER;
437: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
438: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
439: l_next_approver_id NUMBER;
440: l_next_approver_user_name fnd_user.user_name%TYPE;
441: l_next_approver_disp_name wf_users.display_name%TYPE;
442: l_orig_system wf_users.orig_system%TYPE := 'PER';

Line 454: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

450:
451: l_next_approver ame_util.approverRecord;
452: l_insertion_type VARCHAR2(30);
453: l_authority_type VARCHAR2(30);
454: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
455:
456: BEGIN
457: IF (funcmode = 'RUN') THEN
458:

Line 630: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

626: l_value VARCHAR2(2000);
627: l_responder_id NUMBER := NULL;
628: l_forward_to_id NUMBER := NULL;
629: l_end_date DATE; -- notification end date
630: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
631:
632: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
633: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
634: l_preparer_user_name fnd_user.user_name%TYPE;

Line 632: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;

628: l_forward_to_id NUMBER := NULL;
629: l_end_date DATE; -- notification end date
630: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
631:
632: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
633: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
634: l_preparer_user_name fnd_user.user_name%TYPE;
635:
636: BEGIN

Line 633: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;

629: l_end_date DATE; -- notification end date
630: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
631:
632: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
633: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
634: l_preparer_user_name fnd_user.user_name%TYPE;
635:
636: BEGIN
637:

Line 755: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

751: l_progress VARCHAR2(300) := '000';
752: l_approver_id NUMBER := NULL;
753: l_document_id NUMBER;
754: l_doc_string varchar2(200);
755: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
756: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
757: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
758: l_preparer_user_name fnd_user.user_name%TYPE;
759:

Line 756: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;

752: l_approver_id NUMBER := NULL;
753: l_document_id NUMBER;
754: l_doc_string varchar2(200);
755: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
756: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
757: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
758: l_preparer_user_name fnd_user.user_name%TYPE;
759:
760:

Line 757: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;

753: l_document_id NUMBER;
754: l_doc_string varchar2(200);
755: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
756: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
757: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
758: l_preparer_user_name fnd_user.user_name%TYPE;
759:
760:
761: BEGIN