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 215: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;

211: actid in number,
212: funcmode in varchar2,
213: resultout out NOCOPY varchar2) IS
214: l_progress VARCHAR2(100) := '000';
215: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
216: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
217: l_is_ame_approval boolean;
218: l_doc_string varchar2(200);
219: l_preparer_user_name varchar2(100);

Line 216: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;

212: funcmode in varchar2,
213: resultout out NOCOPY varchar2) IS
214: l_progress VARCHAR2(100) := '000';
215: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
216: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
217: l_is_ame_approval boolean;
218: l_doc_string varchar2(200);
219: l_preparer_user_name varchar2(100);
220: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

Line 220: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

216: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
217: l_is_ame_approval boolean;
218: l_doc_string varchar2(200);
219: l_preparer_user_name varchar2(100);
220: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
221:
222: begin
223:
224: IF (funcmode = 'RUN') THEN

Line 241: FROM po_document_types

237:
238:
239: SELECT ame_transaction_type
240: INTO l_transaction_type
241: FROM po_document_types
242: WHERE document_type_code = l_document_type
243: and document_subtype = l_document_subtype;
244:
245: if (l_transaction_type is not null) then

Line 316: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

312: l_progress VARCHAR2(100) := '000';
313: l_is_ame_approval boolean;
314: l_doc_string varchar2(200);
315: l_preparer_user_name varchar2(100);
316: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
317:
318: begin
319:
320: IF (funcmode = 'RUN') THEN

Line 330: FROM po_document_types

326:
327: begin
328: SELECT ame_transaction_type
329: INTO l_transaction_type
330: FROM po_document_types
331: WHERE document_type_code = 'CHANGE_REQUEST'
332: and document_subtype = 'REQUISITION' ;
333: exception
334: when others then

Line 414: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;

410: funcmode in varchar2,
411: resultout out NOCOPY varchar2) IS
412: l_progress VARCHAR2(100) := '000';
413: l_document_id NUMBER;
414: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
415: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
416: l_next_approver_id NUMBER;
417: l_next_approver_user_name fnd_user.user_name%TYPE;
418: l_next_approver_disp_name wf_users.display_name%TYPE;

Line 415: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;

411: resultout out NOCOPY varchar2) IS
412: l_progress VARCHAR2(100) := '000';
413: l_document_id NUMBER;
414: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
415: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
416: l_next_approver_id NUMBER;
417: l_next_approver_user_name fnd_user.user_name%TYPE;
418: l_next_approver_disp_name wf_users.display_name%TYPE;
419: l_orig_system wf_users.orig_system%TYPE := 'PER';

Line 431: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

427:
428: l_next_approver ame_util.approverRecord;
429: l_insertion_type VARCHAR2(30);
430: l_authority_type VARCHAR2(30);
431: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
432:
433: BEGIN
434: IF (funcmode = 'RUN') THEN
435:

Line 607: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

603: l_value VARCHAR2(2000);
604: l_responder_id NUMBER := NULL;
605: l_forward_to_id NUMBER := NULL;
606: l_end_date DATE; -- notification end date
607: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
608:
609: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
610: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
611: l_preparer_user_name fnd_user.user_name%TYPE;

Line 609: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;

605: l_forward_to_id NUMBER := NULL;
606: l_end_date DATE; -- notification end date
607: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
608:
609: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
610: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
611: l_preparer_user_name fnd_user.user_name%TYPE;
612:
613: BEGIN

Line 610: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;

606: l_end_date DATE; -- notification end date
607: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
608:
609: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
610: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
611: l_preparer_user_name fnd_user.user_name%TYPE;
612:
613: BEGIN
614:

Line 732: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;

728: l_progress VARCHAR2(300) := '000';
729: l_approver_id NUMBER := NULL;
730: l_document_id NUMBER;
731: l_doc_string varchar2(200);
732: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
733: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
734: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
735: l_preparer_user_name fnd_user.user_name%TYPE;
736:

Line 733: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;

729: l_approver_id NUMBER := NULL;
730: l_document_id NUMBER;
731: l_doc_string varchar2(200);
732: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
733: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
734: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
735: l_preparer_user_name fnd_user.user_name%TYPE;
736:
737:

Line 734: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;

730: l_document_id NUMBER;
731: l_doc_string varchar2(200);
732: l_transaction_type PO_DOCUMENT_TYPES.AME_TRANSACTION_TYPE%TYPE;
733: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
734: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
735: l_preparer_user_name fnd_user.user_name%TYPE;
736:
737:
738: BEGIN