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_SIGNATURE_PVT dependencies on WF_ITEMS

Line 303: l_item_type WF_ITEMS.item_type%TYPE;

299: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
300: l_buyer_name FND_USER.user_name%TYPE;
301: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
302: l_supplier_response VARCHAR2(20);
303: l_item_type WF_ITEMS.item_type%TYPE;
304: l_item_key WF_ITEMS.item_key%TYPE;
305: l_firstcolon NUMBER;
306: l_secondcolon NUMBER;
307: l_amount NUMBER;

Line 304: l_item_key WF_ITEMS.item_key%TYPE;

300: l_buyer_name FND_USER.user_name%TYPE;
301: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
302: l_supplier_response VARCHAR2(20);
303: l_item_type WF_ITEMS.item_type%TYPE;
304: l_item_key WF_ITEMS.item_key%TYPE;
305: l_firstcolon NUMBER;
306: l_secondcolon NUMBER;
307: l_amount NUMBER;
308: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;

Line 816: l_po_itemtype WF_ITEMS.item_type%TYPE;

812: l_progress VARCHAR2(300);
813: l_doc_string VARCHAR2(200);
814: l_preparer_user_name WF_USERS.name%TYPE;
815: l_result VARCHAR2(1);
816: l_po_itemtype WF_ITEMS.item_type%TYPE;
817: l_po_itemkey WF_ITEMS.item_key%TYPE;
818: l_response_code FND_LOOKUP_VALUES.meaning%TYPE;
819: l_binding_exception EXCEPTION;
820:

Line 817: l_po_itemkey WF_ITEMS.item_key%TYPE;

813: l_doc_string VARCHAR2(200);
814: l_preparer_user_name WF_USERS.name%TYPE;
815: l_result VARCHAR2(1);
816: l_po_itemtype WF_ITEMS.item_type%TYPE;
817: l_po_itemkey WF_ITEMS.item_key%TYPE;
818: l_response_code FND_LOOKUP_VALUES.meaning%TYPE;
819: l_binding_exception EXCEPTION;
820:
821: --

Line 1328: l_item_type WF_ITEMS.item_type%TYPE;

1324: l_msgbody VARCHAR2(32000);
1325: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1326: l_buyer_name FND_USER.user_name%TYPE;
1327: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
1328: l_item_type WF_ITEMS.item_type%TYPE;
1329: l_item_key WF_ITEMS.item_key%TYPE;
1330: l_firstcolon NUMBER;
1331: l_secondcolon NUMBER;
1332: l_amount NUMBER;

Line 1329: l_item_key WF_ITEMS.item_key%TYPE;

1325: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1326: l_buyer_name FND_USER.user_name%TYPE;
1327: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
1328: l_item_type WF_ITEMS.item_type%TYPE;
1329: l_item_key WF_ITEMS.item_key%TYPE;
1330: l_firstcolon NUMBER;
1331: l_secondcolon NUMBER;
1332: l_amount NUMBER;
1333: l_document_number PO_HEADERS_ALL.segment1%TYPE;

Line 1685: l_item_type WF_ITEMS.item_type%TYPE;

1681: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1682: l_buyer_name FND_USER.user_name%TYPE;
1683: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
1684: l_buyer_response VARCHAR2(20);
1685: l_item_type WF_ITEMS.item_type%TYPE;
1686: l_item_key WF_ITEMS.item_key%TYPE;
1687: l_firstcolon NUMBER;
1688: l_secondcolon NUMBER;
1689: l_amount NUMBER;

Line 1686: l_item_key WF_ITEMS.item_key%TYPE;

1682: l_buyer_name FND_USER.user_name%TYPE;
1683: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
1684: l_buyer_response VARCHAR2(20);
1685: l_item_type WF_ITEMS.item_type%TYPE;
1686: l_item_key WF_ITEMS.item_key%TYPE;
1687: l_firstcolon NUMBER;
1688: l_secondcolon NUMBER;
1689: l_amount NUMBER;
1690: l_document_number PO_HEADERS_ALL.segment1%TYPE;

Line 2551: l_itemkey WF_ITEMS.item_key%TYPE := NULL;

2547: p_document_type IN VARCHAR2,
2548: x_itemkey OUT NOCOPY VARCHAR2,
2549: x_result OUT NOCOPY VARCHAR2)
2550: IS
2551: l_itemkey WF_ITEMS.item_key%TYPE := NULL;
2552: l_seq_for_item_key VARCHAR2(10) := null;
2553:
2554: BEGIN
2555:

Line 2605: l_itemkey WF_ITEMS.item_key%TYPE := NULL;

2601: p_document_type IN VARCHAR2,
2602: x_itemkey OUT NOCOPY VARCHAR2,
2603: x_result OUT NOCOPY VARCHAR2)
2604: IS
2605: l_itemkey WF_ITEMS.item_key%TYPE := NULL;
2606: l_itemkey_like VARCHAR2(240);
2607: BEGIN
2608:
2609: l_itemkey_like := 'PO_DOC_BIND_'||p_po_header_id||'_'||p_revision_num||'_'||p_document_type||'%';

Line 2613: FROM WF_ITEMS

2609: l_itemkey_like := 'PO_DOC_BIND_'||p_po_header_id||'_'||p_revision_num||'_'||p_document_type||'%';
2610:
2611: SELECT item_key
2612: INTO l_itemkey
2613: FROM WF_ITEMS
2614: WHERE item_type = 'POAPPRV'
2615: AND item_key LIKE l_itemkey_like
2616: AND end_date IS NULL;
2617:

Line 2655: l_itemkey WF_ITEMS.item_key%TYPE;

2651: -------------------------------------------------------------------------------
2652: PROCEDURE Abort_Doc_Sign_Process(p_itemkey IN VARCHAR2,
2653: x_result OUT NOCOPY VARCHAR2)
2654: IS
2655: l_itemkey WF_ITEMS.item_key%TYPE;
2656: BEGIN
2657: SELECT item_key
2658: INTO l_itemkey
2659: FROM WF_ITEMS

Line 2659: FROM WF_ITEMS

2655: l_itemkey WF_ITEMS.item_key%TYPE;
2656: BEGIN
2657: SELECT item_key
2658: INTO l_itemkey
2659: FROM WF_ITEMS
2660: WHERE item_type = 'POAPPRV'
2661: AND item_key = p_itemkey
2662: AND end_date IS NULL;
2663:

Line 2978: l_po_itemkey WF_ITEMS.item_key%TYPE;

2974: l_supplier_rejected_count PLS_INTEGER := 0;
2975: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
2976: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
2977: l_object_code PO_ACTION_HISTORY.object_type_code%TYPE := NULL;
2978: l_po_itemkey WF_ITEMS.item_key%TYPE;
2979: l_po_itemtype WF_ITEMS.item_type%TYPE;
2980: l_itemkey WF_ITEMS.item_key%TYPE;
2981: l_result VARCHAR2(1);
2982:

Line 2979: l_po_itemtype WF_ITEMS.item_type%TYPE;

2975: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
2976: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
2977: l_object_code PO_ACTION_HISTORY.object_type_code%TYPE := NULL;
2978: l_po_itemkey WF_ITEMS.item_key%TYPE;
2979: l_po_itemtype WF_ITEMS.item_type%TYPE;
2980: l_itemkey WF_ITEMS.item_key%TYPE;
2981: l_result VARCHAR2(1);
2982:
2983: --

Line 2980: l_itemkey WF_ITEMS.item_key%TYPE;

2976: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
2977: l_object_code PO_ACTION_HISTORY.object_type_code%TYPE := NULL;
2978: l_po_itemkey WF_ITEMS.item_key%TYPE;
2979: l_po_itemtype WF_ITEMS.item_type%TYPE;
2980: l_itemkey WF_ITEMS.item_key%TYPE;
2981: l_result VARCHAR2(1);
2982:
2983: --
2984: l_acceptance_date DATE;