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 707: l_can_change_forward_from_flag po_document_types.can_change_forward_from_flag%type;

703: l_revision_num PO_HEADERS.revision_num%TYPE; -- Bug 3215186
704: l_ga_flag VARCHAR2(1) := NULL; -- FPI GA
705: /* RETROACTIVE FPI START */
706: l_seq_for_item_key VARCHAR2(25) := NULL; --Bug14305923
707: l_can_change_forward_from_flag po_document_types.can_change_forward_from_flag%type;
708: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
709: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
710: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
711: l_default_approval_path_id po_document_types.default_approval_path_id%type;

Line 708: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;

704: l_ga_flag VARCHAR2(1) := NULL; -- FPI GA
705: /* RETROACTIVE FPI START */
706: l_seq_for_item_key VARCHAR2(25) := NULL; --Bug14305923
707: l_can_change_forward_from_flag po_document_types.can_change_forward_from_flag%type;
708: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
709: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
710: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
711: l_default_approval_path_id po_document_types.default_approval_path_id%type;
712: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;

Line 709: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;

705: /* RETROACTIVE FPI START */
706: l_seq_for_item_key VARCHAR2(25) := NULL; --Bug14305923
707: l_can_change_forward_from_flag po_document_types.can_change_forward_from_flag%type;
708: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
709: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
710: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
711: l_default_approval_path_id po_document_types.default_approval_path_id%type;
712: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
713: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;

Line 710: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;

706: l_seq_for_item_key VARCHAR2(25) := NULL; --Bug14305923
707: l_can_change_forward_from_flag po_document_types.can_change_forward_from_flag%type;
708: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
709: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
710: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
711: l_default_approval_path_id po_document_types.default_approval_path_id%type;
712: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
713: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
714: l_itemtype po_document_types.wf_approval_itemtype%type;

Line 711: l_default_approval_path_id po_document_types.default_approval_path_id%type;

707: l_can_change_forward_from_flag po_document_types.can_change_forward_from_flag%type;
708: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
709: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
710: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
711: l_default_approval_path_id po_document_types.default_approval_path_id%type;
712: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
713: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
714: l_itemtype po_document_types.wf_approval_itemtype%type;
715: l_itemtype_st po_document_types.wf_approval_itemtype%type;

Line 712: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;

708: l_can_change_forward_to_flag po_document_types.can_change_forward_to_flag%type;
709: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
710: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
711: l_default_approval_path_id po_document_types.default_approval_path_id%type;
712: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
713: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
714: l_itemtype po_document_types.wf_approval_itemtype%type;
715: l_itemtype_st po_document_types.wf_approval_itemtype%type;
716: l_workflow_process po_document_types.wf_approval_process%type;

Line 713: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;

709: l_can_change_approval_path po_document_types.can_change_approval_path_flag%type;
710: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
711: l_default_approval_path_id po_document_types.default_approval_path_id%type;
712: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
713: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
714: l_itemtype po_document_types.wf_approval_itemtype%type;
715: l_itemtype_st po_document_types.wf_approval_itemtype%type;
716: l_workflow_process po_document_types.wf_approval_process%type;
717: l_workflow_process_st po_document_types.wf_approval_process%type;

Line 714: l_itemtype po_document_types.wf_approval_itemtype%type;

710: l_can_preparer_approve_flag po_document_types.can_preparer_approve_flag%type;
711: l_default_approval_path_id po_document_types.default_approval_path_id%type;
712: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
713: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
714: l_itemtype po_document_types.wf_approval_itemtype%type;
715: l_itemtype_st po_document_types.wf_approval_itemtype%type;
716: l_workflow_process po_document_types.wf_approval_process%type;
717: l_workflow_process_st po_document_types.wf_approval_process%type;
718: l_itemkey VARCHAR2(60);

Line 715: l_itemtype_st po_document_types.wf_approval_itemtype%type;

711: l_default_approval_path_id po_document_types.default_approval_path_id%type;
712: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
713: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
714: l_itemtype po_document_types.wf_approval_itemtype%type;
715: l_itemtype_st po_document_types.wf_approval_itemtype%type;
716: l_workflow_process po_document_types.wf_approval_process%type;
717: l_workflow_process_st po_document_types.wf_approval_process%type;
718: l_itemkey VARCHAR2(60);
719: l_type_name po_document_types.type_name%type;

Line 716: l_workflow_process po_document_types.wf_approval_process%type;

712: l_can_approver_modify_flag po_document_types.can_approver_modify_doc_flag%type;
713: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
714: l_itemtype po_document_types.wf_approval_itemtype%type;
715: l_itemtype_st po_document_types.wf_approval_itemtype%type;
716: l_workflow_process po_document_types.wf_approval_process%type;
717: l_workflow_process_st po_document_types.wf_approval_process%type;
718: l_itemkey VARCHAR2(60);
719: l_type_name po_document_types.type_name%type;
720: /* RETROACTIVE FPI END */

Line 717: l_workflow_process_st po_document_types.wf_approval_process%type;

713: l_forwarding_mode_code po_document_types.forwarding_mode_code%type;
714: l_itemtype po_document_types.wf_approval_itemtype%type;
715: l_itemtype_st po_document_types.wf_approval_itemtype%type;
716: l_workflow_process po_document_types.wf_approval_process%type;
717: l_workflow_process_st po_document_types.wf_approval_process%type;
718: l_itemkey VARCHAR2(60);
719: l_type_name po_document_types.type_name%type;
720: /* RETROACTIVE FPI END */
721: l_drop_ship_flag po_line_locations.drop_ship_flag%type; --

Line 719: l_type_name po_document_types.type_name%type;

715: l_itemtype_st po_document_types.wf_approval_itemtype%type;
716: l_workflow_process po_document_types.wf_approval_process%type;
717: l_workflow_process_st po_document_types.wf_approval_process%type;
718: l_itemkey VARCHAR2(60);
719: l_type_name po_document_types.type_name%type;
720: /* RETROACTIVE FPI END */
721: l_drop_ship_flag po_line_locations.drop_ship_flag%type; --
722: l_conterms_exist_flag PO_HEADERS_ALL.CONTERMS_EXIST_FLAG%TYPE; --
723: --bug##3682458 replaced legal entity name with operating unit

Line 774: * Get the itemtype and WorkflowProcess from po_document_types

770: -- - If a process is not passed then the selector function defined in
771: -- item type will be determine which process to run
772: --
773: /* RETROACTIVE FPI START.
774: * Get the itemtype and WorkflowProcess from po_document_types
775: * if it is not set.
776: */
777: IF ((ItemType IS NULL) OR (WorkflowProcess IS NULL)) THEN
778: po_approve_sv.get_document_types

Line 1763: FROM po_document_types

1759: l_preparer_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'PREPARER_ID');
1760: /*7125551, including the sql to get the value of l_can_modify_flag here*/
1761: SELECT CAN_APPROVER_MODIFY_DOC_FLAG
1762: INTO l_can_modify_flag
1763: FROM po_document_types
1764: WHERE DOCUMENT_TYPE_CODE = l_document_type
1765: AND DOCUMENT_SUBTYPE = l_doc_subtype;
1766:
1767: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'APPROVER_EMPID', avalue => l_preparer_id);

Line 3112: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;

3108: x_progress VARCHAR2(100);
3109: l_doc_string VARCHAR2(200);
3110: l_preparer_user_name VARCHAR2(100);
3111: /* <> */
3112: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
3113: l_document_id NUMBER;
3114: l_is_clm_doc VARCHAR2(1) := NULL ;
3115: /* <> */
3116: BEGIN

Line 3413: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;

3409: l_create_sr_asl VARCHAR2(2);
3410: x_progress VARCHAR2(300);
3411: l_doc_string VARCHAR2(200);
3412: l_preparer_user_name VARCHAR2(100);
3413: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
3414: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
3415: l_resp_id NUMBER;
3416: l_user_id NUMBER;
3417: l_appl_id NUMBER;

Line 3414: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;

3410: x_progress VARCHAR2(300);
3411: l_doc_string VARCHAR2(200);
3412: l_preparer_user_name VARCHAR2(100);
3413: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
3414: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
3415: l_resp_id NUMBER;
3416: l_user_id NUMBER;
3417: l_appl_id NUMBER;
3418: BEGIN

Line 3487: l_document_subtype po_document_types.document_subtype%type;

3483: l_orgid NUMBER;
3484: l_send_notif VARCHAR2(2);
3485: x_progress VARCHAR2(300);
3486: l_document_type VARCHAR2(25);
3487: l_document_subtype po_document_types.document_subtype%type;
3488: l_document_id NUMBER;
3489: l_notifier VARCHAR2(100);
3490: l_doc_string VARCHAR2(200);
3491: l_preparer_user_name VARCHAR2(100);

Line 3545: l_document_subtype po_document_types.document_subtype%type;

3541: l_orgid NUMBER;
3542: l_send_notif VARCHAR2(2);
3543: x_progress VARCHAR2(300);
3544: l_document_type VARCHAR2(25);
3545: l_document_subtype po_document_types.document_subtype%type;
3546: l_document_id NUMBER;
3547: l_notifier VARCHAR2(100);
3548: l_notifier_resp VARCHAR2(100);
3549: l_doc_string VARCHAR2(200);

Line 3621: l_document_subtype po_document_types.document_subtype%type;

3617: l_orgid NUMBER;
3618: l_send_notif VARCHAR2(2);
3619: x_progress VARCHAR2(300);
3620: l_document_type VARCHAR2(25);
3621: l_document_subtype po_document_types.document_subtype%type;
3622: l_document_id NUMBER;
3623: l_notifier VARCHAR2(100);
3624: l_doc_string VARCHAR2(200);
3625: l_preparer_user_name VARCHAR2(100);

Line 4661: ** po document types.

4657: WHERE lookup_type='DOCUMENT STATE'
4658: AND lookup_code = p_closed_code;
4659: /* Bug# 2616355: kagarwal
4660: ** Desc: We will get the document type display value from
4661: ** po document types.
4662: */
4663: CURSOR c3(p_doc_type VARCHAR2, p_doc_subtype VARCHAR2)
4664: IS
4665: SELECT type_name

Line 4666: FROM po_document_types

4662: */
4663: CURSOR c3(p_doc_type VARCHAR2, p_doc_subtype VARCHAR2)
4664: IS
4665: SELECT type_name
4666: FROM po_document_types
4667: WHERE document_type_code = p_doc_type
4668: AND document_subtype = p_doc_subtype;
4669: /*
4670: cursor c4(p_doc_subtype varchar2) is

Line 5217: FROM po_document_types

5213: IS
5214: CURSOR C1(p_document_type_code VARCHAR2, p_document_subtype VARCHAR2)
5215: IS
5216: SELECT NVL(can_preparer_approve_flag,'N')
5217: FROM po_document_types
5218: WHERE document_type_code = p_document_type_code
5219: AND document_subtype = p_document_subtype;
5220:
5221: l_document_type_code VARCHAR2(25);

Line 7315: ** po document types.

7311: l_release_num NUMBER; --1942901
7312: l_document_id PO_HEADERS_ALL.po_header_id%TYPE; --
7313: /* Bug# 2655410: kagarwal
7314: ** Desc: We will get the document type display value from
7315: ** po document types.
7316: */
7317: CURSOR docDisp(p_doc_type VARCHAR2, p_doc_subtype VARCHAR2)
7318: IS
7319: SELECT type_name

Line 7320: FROM po_document_types

7316: */
7317: CURSOR docDisp(p_doc_type VARCHAR2, p_doc_subtype VARCHAR2)
7318: IS
7319: SELECT type_name
7320: FROM po_document_types
7321: WHERE document_type_code = p_doc_type
7322: AND document_subtype = p_doc_subtype;
7323: BEGIN
7324: IF (funcmode ='RUN') THEN

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

7336: l_preparer_id := PO_WF_UTIL_PKG.GetItemAttrNumber ( itemtype => l_item_type, itemkey => l_item_key, aname => 'PREPARER_ID');
7337: PO_REQAPPROVAL_INIT1.get_user_name(l_preparer_id, l_name, l_disp);
7338: /* Bug# 2655410: kagarwal
7339: ** Desc: We will get the document type display value from
7340: ** po document types. Hence we need to get the doc type and subtype
7341: ** from the parent wf and then set the doc type display in the
7342: ** error wf.
7343: **
7344: ** Also need to set the org context before calling the cursor

Line 7412: l_document_type po_document_types.document_type_code%type;

7408: IS
7409: l_acceptance_flag po_headers_all.acceptance_required_flag%TYPE;
7410: x_progress VARCHAR2(3) := '000';
7411: l_document_id NUMBER;
7412: l_document_type po_document_types.document_type_code%type;
7413: l_document_subtype po_document_types.document_subtype%type;
7414: l_when_to_archive po_document_types.archive_external_revision_code%type;
7415: l_archive_result VARCHAR2(1);
7416: l_revision_num NUMBER; -- --

Line 7413: l_document_subtype po_document_types.document_subtype%type;

7409: l_acceptance_flag po_headers_all.acceptance_required_flag%TYPE;
7410: x_progress VARCHAR2(3) := '000';
7411: l_document_id NUMBER;
7412: l_document_type po_document_types.document_type_code%type;
7413: l_document_subtype po_document_types.document_subtype%type;
7414: l_when_to_archive po_document_types.archive_external_revision_code%type;
7415: l_archive_result VARCHAR2(1);
7416: l_revision_num NUMBER; -- --
7417: l_responded_shipments NUMBER; -- --

Line 7414: l_when_to_archive po_document_types.archive_external_revision_code%type;

7410: x_progress VARCHAR2(3) := '000';
7411: l_document_id NUMBER;
7412: l_document_type po_document_types.document_type_code%type;
7413: l_document_subtype po_document_types.document_subtype%type;
7414: l_when_to_archive po_document_types.archive_external_revision_code%type;
7415: l_archive_result VARCHAR2(1);
7416: l_revision_num NUMBER; -- --
7417: l_responded_shipments NUMBER; -- --
7418: BEGIN

Line 7985: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;

7981: l_massupdate_releases VARCHAR2(2);
7982: l_progress VARCHAR2(300);
7983: l_doc_string VARCHAR2(200);
7984: l_preparer_user_name VARCHAR2(100);
7985: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
7986: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
7987: l_resp_id NUMBER;
7988: l_user_id NUMBER;
7989: l_appl_id NUMBER;

Line 7986: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;

7982: l_progress VARCHAR2(300);
7983: l_doc_string VARCHAR2(200);
7984: l_preparer_user_name VARCHAR2(100);
7985: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
7986: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
7987: l_resp_id NUMBER;
7988: l_user_id NUMBER;
7989: l_appl_id NUMBER;
7990: BEGIN

Line 8130: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;

8126: IS
8127: l_retro_change VARCHAR2(1);
8128: l_supplier_comm VARCHAR2(1) := 'Y'; --default has to be Y
8129: l_progress VARCHAR2(300);
8130: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
8131: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
8132: BEGIN
8133: l_progress := 'PO_REQAPPROVAL_INIT1.Send_Supplier_Comm_Yes_No: 01';
8134: l_retro_change := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CO_R_RETRO_CHANGE');

Line 8131: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;

8127: l_retro_change VARCHAR2(1);
8128: l_supplier_comm VARCHAR2(1) := 'Y'; --default has to be Y
8129: l_progress VARCHAR2(300);
8130: l_document_type PO_DOCUMENT_TYPES_ALL.DOCUMENT_TYPE_CODE%TYPE;
8131: l_document_subtype PO_DOCUMENT_TYPES_ALL.DOCUMENT_SUBTYPE%TYPE;
8132: BEGIN
8133: l_progress := 'PO_REQAPPROVAL_INIT1.Send_Supplier_Comm_Yes_No: 01';
8134: l_retro_change := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype, itemkey => itemkey, aname => 'CO_R_RETRO_CHANGE');
8135: -- Bug 3694128 : get the document type and subtype

Line 8205: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;

8201: resultout OUT NOCOPY VARCHAR2)
8202: IS
8203: l_retro_change VARCHAR2(1);
8204: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
8205: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
8206: l_progress VARCHAR2(2000);
8207: l_update_releases VARCHAR2(1) := 'Y';
8208: l_return_status VARCHAR2(1) ;
8209: l_msg_count NUMBER := 0;