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 376: l_item_type WF_ITEMS.item_type%TYPE;

372: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
373: l_buyer_name FND_USER.user_name%TYPE;
374: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
375: l_supplier_response VARCHAR2(20);
376: l_item_type WF_ITEMS.item_type%TYPE;
377: l_item_key WF_ITEMS.item_key%TYPE;
378: l_firstcolon NUMBER;
379: l_secondcolon NUMBER;
380: l_amount NUMBER;

Line 377: l_item_key WF_ITEMS.item_key%TYPE;

373: l_buyer_name FND_USER.user_name%TYPE;
374: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
375: l_supplier_response VARCHAR2(20);
376: l_item_type WF_ITEMS.item_type%TYPE;
377: l_item_key WF_ITEMS.item_key%TYPE;
378: l_firstcolon NUMBER;
379: l_secondcolon NUMBER;
380: l_amount NUMBER;
381: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;

Line 946: l_po_itemtype WF_ITEMS.item_type%TYPE;

942: l_progress VARCHAR2(300);
943: l_doc_string VARCHAR2(200);
944: l_preparer_user_name WF_USERS.name%TYPE;
945: l_result VARCHAR2(1);
946: l_po_itemtype WF_ITEMS.item_type%TYPE;
947: l_po_itemkey WF_ITEMS.item_key%TYPE;
948: l_response_code FND_LOOKUP_VALUES.meaning%TYPE;
949: l_binding_exception EXCEPTION;
950:

Line 947: l_po_itemkey WF_ITEMS.item_key%TYPE;

943: l_doc_string VARCHAR2(200);
944: l_preparer_user_name WF_USERS.name%TYPE;
945: l_result VARCHAR2(1);
946: l_po_itemtype WF_ITEMS.item_type%TYPE;
947: l_po_itemkey WF_ITEMS.item_key%TYPE;
948: l_response_code FND_LOOKUP_VALUES.meaning%TYPE;
949: l_binding_exception EXCEPTION;
950:
951: --

Line 1671: l_item_type WF_ITEMS.item_type%TYPE;

1667: l_msgbody VARCHAR2(32000);
1668: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1669: l_buyer_name FND_USER.user_name%TYPE;
1670: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
1671: l_item_type WF_ITEMS.item_type%TYPE;
1672: l_item_key WF_ITEMS.item_key%TYPE;
1673: l_firstcolon NUMBER;
1674: l_secondcolon NUMBER;
1675: l_amount NUMBER;

Line 1672: l_item_key WF_ITEMS.item_key%TYPE;

1668: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1669: l_buyer_name FND_USER.user_name%TYPE;
1670: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
1671: l_item_type WF_ITEMS.item_type%TYPE;
1672: l_item_key WF_ITEMS.item_key%TYPE;
1673: l_firstcolon NUMBER;
1674: l_secondcolon NUMBER;
1675: l_amount NUMBER;
1676: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;

Line 2036: l_item_type WF_ITEMS.item_type%TYPE;

2032: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2033: l_buyer_name FND_USER.user_name%TYPE;
2034: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
2035: l_buyer_response VARCHAR2(20);
2036: l_item_type WF_ITEMS.item_type%TYPE;
2037: l_item_key WF_ITEMS.item_key%TYPE;
2038: l_firstcolon NUMBER;
2039: l_secondcolon NUMBER;
2040: l_amount NUMBER;

Line 2037: l_item_key WF_ITEMS.item_key%TYPE;

2033: l_buyer_name FND_USER.user_name%TYPE;
2034: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
2035: l_buyer_response VARCHAR2(20);
2036: l_item_type WF_ITEMS.item_type%TYPE;
2037: l_item_key WF_ITEMS.item_key%TYPE;
2038: l_firstcolon NUMBER;
2039: l_secondcolon NUMBER;
2040: l_amount NUMBER;
2041: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;

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

3290: p_document_type IN VARCHAR2,
3291: x_itemkey OUT NOCOPY VARCHAR2,
3292: x_result OUT NOCOPY VARCHAR2)
3293: IS
3294: l_itemkey WF_ITEMS.item_key%TYPE := NULL;
3295: l_seq_for_item_key VARCHAR2(25) := null; --Bug14305923
3296:
3297: BEGIN
3298:

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

3344: p_document_type IN VARCHAR2,
3345: x_itemkey OUT NOCOPY VARCHAR2,
3346: x_result OUT NOCOPY VARCHAR2)
3347: IS
3348: l_itemkey WF_ITEMS.item_key%TYPE := NULL;
3349: l_itemkey_like VARCHAR2(240);
3350: BEGIN
3351:
3352: l_itemkey_like := 'PO_DOC_BIND_'||p_po_header_id||'_'||p_revision_num||'_'||p_document_type||'%';

Line 3356: FROM WF_ITEMS

3352: l_itemkey_like := 'PO_DOC_BIND_'||p_po_header_id||'_'||p_revision_num||'_'||p_document_type||'%';
3353:
3354: SELECT item_key
3355: INTO l_itemkey
3356: FROM WF_ITEMS
3357: WHERE item_type = 'POAPPRV'
3358: AND item_key LIKE l_itemkey_like
3359: AND end_date IS NULL;
3360:

Line 3398: l_itemkey WF_ITEMS.item_key%TYPE;

3394: -------------------------------------------------------------------------------
3395: PROCEDURE Abort_Doc_Sign_Process(p_itemkey IN VARCHAR2,
3396: x_result OUT NOCOPY VARCHAR2)
3397: IS
3398: l_itemkey WF_ITEMS.item_key%TYPE;
3399: BEGIN
3400: SELECT item_key
3401: INTO l_itemkey
3402: FROM WF_ITEMS

Line 3402: FROM WF_ITEMS

3398: l_itemkey WF_ITEMS.item_key%TYPE;
3399: BEGIN
3400: SELECT item_key
3401: INTO l_itemkey
3402: FROM WF_ITEMS
3403: WHERE item_type = 'POAPPRV'
3404: AND item_key = p_itemkey
3405: AND end_date IS NULL;
3406:

Line 3721: l_po_itemkey WF_ITEMS.item_key%TYPE;

3717: l_supplier_rejected_count PLS_INTEGER := 0;
3718: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
3719: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
3720: l_object_code PO_ACTION_HISTORY.object_type_code%TYPE := NULL;
3721: l_po_itemkey WF_ITEMS.item_key%TYPE;
3722: l_po_itemtype WF_ITEMS.item_type%TYPE;
3723: l_itemkey WF_ITEMS.item_key%TYPE;
3724: l_result VARCHAR2(1);
3725:

Line 3722: l_po_itemtype WF_ITEMS.item_type%TYPE;

3718: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
3719: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
3720: l_object_code PO_ACTION_HISTORY.object_type_code%TYPE := NULL;
3721: l_po_itemkey WF_ITEMS.item_key%TYPE;
3722: l_po_itemtype WF_ITEMS.item_type%TYPE;
3723: l_itemkey WF_ITEMS.item_key%TYPE;
3724: l_result VARCHAR2(1);
3725:
3726: --

Line 3723: l_itemkey WF_ITEMS.item_key%TYPE;

3719: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
3720: l_object_code PO_ACTION_HISTORY.object_type_code%TYPE := NULL;
3721: l_po_itemkey WF_ITEMS.item_key%TYPE;
3722: l_po_itemtype WF_ITEMS.item_type%TYPE;
3723: l_itemkey WF_ITEMS.item_key%TYPE;
3724: l_result VARCHAR2(1);
3725:
3726: --
3727: l_acceptance_date DATE;