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.PO_REQAPPROVAL_INIT1 dependencies on PO_DOCUMENT_TYPES

Line 638: po_document_types.can_change_forward_from_flag%type;

634:
635: /* RETROACTIVE FPI START */
636: l_seq_for_item_key varchar2(6) := null;
637: l_can_change_forward_from_flag
638: po_document_types.can_change_forward_from_flag%type;
639: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
640: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
641: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
642: l_default_approval_path_id po_document_types.default_approval_path_id%type;

Line 639: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;

635: /* RETROACTIVE FPI START */
636: l_seq_for_item_key varchar2(6) := null;
637: l_can_change_forward_from_flag
638: po_document_types.can_change_forward_from_flag%type;
639: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
640: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
641: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
642: l_default_approval_path_id po_document_types.default_approval_path_id%type;
643: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;

Line 640: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;

636: l_seq_for_item_key varchar2(6) := null;
637: l_can_change_forward_from_flag
638: po_document_types.can_change_forward_from_flag%type;
639: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
640: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
641: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
642: l_default_approval_path_id po_document_types.default_approval_path_id%type;
643: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
644: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;

Line 641: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;

637: l_can_change_forward_from_flag
638: po_document_types.can_change_forward_from_flag%type;
639: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
640: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
641: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
642: l_default_approval_path_id po_document_types.default_approval_path_id%type;
643: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
644: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
645: l_itemtype po_document_types.wf_approval_itemtype%type;

Line 642: l_default_approval_path_id po_document_types.default_approval_path_id%type;

638: po_document_types.can_change_forward_from_flag%type;
639: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
640: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
641: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
642: l_default_approval_path_id po_document_types.default_approval_path_id%type;
643: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
644: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
645: l_itemtype po_document_types.wf_approval_itemtype%type;
646: l_workflow_process po_document_types.wf_approval_process%type;

Line 643: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;

639: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
640: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
641: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
642: l_default_approval_path_id po_document_types.default_approval_path_id%type;
643: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
644: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
645: l_itemtype po_document_types.wf_approval_itemtype%type;
646: l_workflow_process po_document_types.wf_approval_process%type;
647: l_itemkey varchar2(60);

Line 644: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;

640: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
641: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
642: l_default_approval_path_id po_document_types.default_approval_path_id%type;
643: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
644: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
645: l_itemtype po_document_types.wf_approval_itemtype%type;
646: l_workflow_process po_document_types.wf_approval_process%type;
647: l_itemkey varchar2(60);
648: l_type_name po_document_types.type_name%type;

Line 645: l_itemtype po_document_types.wf_approval_itemtype%type;

641: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
642: l_default_approval_path_id po_document_types.default_approval_path_id%type;
643: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
644: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
645: l_itemtype po_document_types.wf_approval_itemtype%type;
646: l_workflow_process po_document_types.wf_approval_process%type;
647: l_itemkey varchar2(60);
648: l_type_name po_document_types.type_name%type;
649:

Line 646: l_workflow_process po_document_types.wf_approval_process%type;

642: l_default_approval_path_id po_document_types.default_approval_path_id%type;
643: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
644: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
645: l_itemtype po_document_types.wf_approval_itemtype%type;
646: l_workflow_process po_document_types.wf_approval_process%type;
647: l_itemkey varchar2(60);
648: l_type_name po_document_types.type_name%type;
649:
650: /* RETROACTIVE FPI END */

Line 648: l_type_name po_document_types.type_name%type;

644: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
645: l_itemtype po_document_types.wf_approval_itemtype%type;
646: l_workflow_process po_document_types.wf_approval_process%type;
647: l_itemkey varchar2(60);
648: l_type_name po_document_types.type_name%type;
649:
650: /* RETROACTIVE FPI END */
651:
652: l_drop_ship_flag po_line_locations.drop_ship_flag%type; --

Line 685: * Get the itemtype and WorkflowProcess from po_document_types

681: -- item type will be determine which process to run
682: --
683:
684: /* RETROACTIVE FPI START.
685: * Get the itemtype and WorkflowProcess from po_document_types
686: * if it is not set.
687: */
688:
689: If ((ItemType is NULL) or (WorkflowProcess is NULL)) then

Line 1813: FROM po_document_types

1809: /*7125551, including the sql to get the value of l_can_modify_flag here*/
1810:
1811: SELECT CAN_APPROVER_MODIFY_DOC_FLAG
1812: INTO l_can_modify_flag
1813: FROM po_document_types
1814: WHERE DOCUMENT_TYPE_CODE = l_document_type
1815: AND DOCUMENT_SUBTYPE = l_doc_subtype;
1816:
1817: wf_engine.SetItemAttrNumber (itemtype => itemtype,

Line 2204: FROM po_document_types

2200: that the l_can_modify_flag can be used elsewhere also*/
2201:
2202: /*SELECT CAN_APPROVER_MODIFY_DOC_FLAG
2203: INTO l_can_modify_flag
2204: FROM po_document_types
2205: WHERE DOCUMENT_TYPE_CODE = l_document_type
2206: AND DOCUMENT_SUBTYPE = l_doc_subtype;*/
2207:
2208: -- Not showing the open form icon if this is an IP req and owner can't

Line 3936: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;

3932: x_progress varchar2(300);
3933:
3934: l_doc_string varchar2(200);
3935: l_preparer_user_name varchar2(100);
3936: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
3937: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
3938:
3939: l_resp_id number;
3940: l_user_id number;

Line 3937: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;

3933:
3934: l_doc_string varchar2(200);
3935: l_preparer_user_name varchar2(100);
3936: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
3937: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
3938:
3939: l_resp_id number;
3940: l_user_id number;
3941: l_appl_id number;

Line 4049: l_document_subtype po_document_types.document_subtype%type;

4045: x_progress varchar2(300);
4046:
4047:
4048: l_document_type varchar2(25);
4049: l_document_subtype po_document_types.document_subtype%type;
4050: l_document_id number;
4051: l_notifier varchar2(100);
4052:
4053: l_doc_string varchar2(200);

Line 4133: l_document_subtype po_document_types.document_subtype%type;

4129: x_progress varchar2(300);
4130:
4131:
4132: l_document_type varchar2(25);
4133: l_document_subtype po_document_types.document_subtype%type;
4134: l_document_id number;
4135: l_notifier varchar2(100);
4136: l_notifier_resp varchar2(100);
4137:

Line 4245: l_document_subtype po_document_types.document_subtype%type;

4241: x_progress varchar2(300);
4242:
4243:
4244: l_document_type varchar2(25);
4245: l_document_subtype po_document_types.document_subtype%type;
4246: l_document_id number;
4247: l_notifier varchar2(100);
4248:
4249: l_doc_string varchar2(200);

Line 5509: ** po document types.

5505: and lookup_code = p_closed_code;
5506:
5507: /* Bug# 2616355: kagarwal
5508: ** Desc: We will get the document type display value from
5509: ** po document types.
5510: */
5511:
5512: cursor c3(p_doc_type varchar2, p_doc_subtype varchar2) is
5513: select type_name

Line 5514: from po_document_types

5510: */
5511:
5512: cursor c3(p_doc_type varchar2, p_doc_subtype varchar2) is
5513: select type_name
5514: from po_document_types
5515: where document_type_code = p_doc_type
5516: and document_subtype = p_doc_subtype;
5517:
5518: /*

Line 6128: from po_document_types

6124: is
6125:
6126: Cursor C1(p_document_type_code VARCHAR2, p_document_subtype VARCHAR2) is
6127: select NVL(can_preparer_approve_flag,'N')
6128: from po_document_types
6129: where document_type_code = p_document_type_code
6130: and document_subtype = p_document_subtype;
6131:
6132: l_document_type_code VARCHAR2(25);

Line 8128: ** po document types.

8124: l_document_id PO_HEADERS_ALL.po_header_id%TYPE; --
8125:
8126: /* Bug# 2655410: kagarwal
8127: ** Desc: We will get the document type display value from
8128: ** po document types.
8129: */
8130:
8131: cursor docDisp(p_doc_type varchar2, p_doc_subtype varchar2) is
8132: select type_name

Line 8133: from po_document_types

8129: */
8130:
8131: cursor docDisp(p_doc_type varchar2, p_doc_subtype varchar2) is
8132: select type_name
8133: from po_document_types
8134: where document_type_code = p_doc_type
8135: and document_subtype = p_doc_subtype;
8136:
8137:

Line 8167: ** po document types. Hence we need to get the doc type and subtype

8163: PO_REQAPPROVAL_INIT1.get_user_name(l_preparer_id, l_name, l_disp);
8164:
8165: /* Bug# 2655410: kagarwal
8166: ** Desc: We will get the document type display value from
8167: ** po document types. Hence we need to get the doc type and subtype
8168: ** from the parent wf and then set the doc type display in the
8169: ** error wf.
8170: **
8171: ** Also need to set the org context before calling the cursor

Line 8322: l_document_type po_document_types.document_type_code%type;

8318: is
8319: l_acceptance_flag po_headers_all.acceptance_required_flag%TYPE;
8320: x_progress varchar2(3) := '000';
8321: l_document_id number;
8322: l_document_type po_document_types.document_type_code%type;
8323: l_document_subtype po_document_types.document_subtype%type;
8324: l_when_to_archive po_document_types.archive_external_revision_code%type;
8325: l_archive_result varchar2(1);
8326: l_revision_num number; -- --

Line 8323: l_document_subtype po_document_types.document_subtype%type;

8319: l_acceptance_flag po_headers_all.acceptance_required_flag%TYPE;
8320: x_progress varchar2(3) := '000';
8321: l_document_id number;
8322: l_document_type po_document_types.document_type_code%type;
8323: l_document_subtype po_document_types.document_subtype%type;
8324: l_when_to_archive po_document_types.archive_external_revision_code%type;
8325: l_archive_result varchar2(1);
8326: l_revision_num number; -- --
8327: l_responded_shipments number; -- --

Line 8324: l_when_to_archive po_document_types.archive_external_revision_code%type;

8320: x_progress varchar2(3) := '000';
8321: l_document_id number;
8322: l_document_type po_document_types.document_type_code%type;
8323: l_document_subtype po_document_types.document_subtype%type;
8324: l_when_to_archive po_document_types.archive_external_revision_code%type;
8325: l_archive_result varchar2(1);
8326: l_revision_num number; -- --
8327: l_responded_shipments number; -- --
8328: begin

Line 9083: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;

9079: l_progress varchar2(300);
9080:
9081: l_doc_string varchar2(200);
9082: l_preparer_user_name varchar2(100);
9083: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
9084: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
9085:
9086: l_resp_id number;
9087: l_user_id number;

Line 9084: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;

9080:
9081: l_doc_string varchar2(200);
9082: l_preparer_user_name varchar2(100);
9083: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
9084: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
9085:
9086: l_resp_id number;
9087: l_user_id number;
9088: l_appl_id number;

Line 9278: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;

9274: resultout out NOCOPY varchar2 ) IS
9275: l_retro_change varchar2(1);
9276: l_supplier_comm varchar2(1) := 'Y'; --default has to be Y
9277: l_progress varchar2(300);
9278: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
9279: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
9280:
9281: BEGIN
9282: l_progress := 'PO_REQAPPROVAL_INIT1.Send_Supplier_Comm_Yes_No: 01';

Line 9279: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;

9275: l_retro_change varchar2(1);
9276: l_supplier_comm varchar2(1) := 'Y'; --default has to be Y
9277: l_progress varchar2(300);
9278: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
9279: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
9280:
9281: BEGIN
9282: l_progress := 'PO_REQAPPROVAL_INIT1.Send_Supplier_Comm_Yes_No: 01';
9283:

Line 9380: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;

9376: IS
9377:
9378: l_retro_change VARCHAR2(1);
9379: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
9380: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
9381: l_progress VARCHAR2(2000);
9382: l_update_releases VARCHAR2(1) := 'Y';
9383: l_return_status VARCHAR2(1) ;
9384: l_msg_count NUMBER := 0;