DBA Data[Home] [Help]

APPS.PO_CLOSEOUT_PVT dependencies on WF_ITEMS

Line 2965: l_itemtype WF_ITEMS.item_type%TYPE;

2961:
2962: l_message_type VARCHAR2(300);
2963: l_firstcolon NUMBER;
2964: l_secondcolon NUMBER;
2965: l_itemtype WF_ITEMS.item_type%TYPE;
2966: l_itemkey WF_ITEMS.item_key%TYPE;
2967:
2968: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'get_clsout_err_msg_body';
2969: d_position NUMBER;

Line 2966: l_itemkey WF_ITEMS.item_key%TYPE;

2962: l_message_type VARCHAR2(300);
2963: l_firstcolon NUMBER;
2964: l_secondcolon NUMBER;
2965: l_itemtype WF_ITEMS.item_type%TYPE;
2966: l_itemkey WF_ITEMS.item_key%TYPE;
2967:
2968: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'get_clsout_err_msg_body';
2969: d_position NUMBER;
2970:

Line 3065: l_itemtype WF_ITEMS.item_type%TYPE;

3061:
3062: l_messages VARCHAR2(32000);
3063: l_firstcolon NUMBER;
3064: l_secondcolon NUMBER;
3065: l_itemtype WF_ITEMS.item_type%TYPE;
3066: l_itemkey WF_ITEMS.item_key%TYPE;
3067:
3068: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'get_val_notfn_body';
3069: d_position NUMBER;

Line 3066: l_itemkey WF_ITEMS.item_key%TYPE;

3062: l_messages VARCHAR2(32000);
3063: l_firstcolon NUMBER;
3064: l_secondcolon NUMBER;
3065: l_itemtype WF_ITEMS.item_type%TYPE;
3066: l_itemkey WF_ITEMS.item_key%TYPE;
3067:
3068: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'get_val_notfn_body';
3069: d_position NUMBER;
3070:

Line 3740: l_item_type WF_ITEMS.item_type%TYPE;

3736: l_msgbody VARCHAR2(32000);
3737: l_progress VARCHAR2(300);
3738:
3739: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
3740: l_item_type WF_ITEMS.item_type%TYPE;
3741: l_item_key WF_ITEMS.item_key%TYPE;
3742: l_firstcolon NUMBER;
3743: l_secondcolon NUMBER;
3744: l_itemtype WF_ITEMS.item_type%TYPE;

Line 3741: l_item_key WF_ITEMS.item_key%TYPE;

3737: l_progress VARCHAR2(300);
3738:
3739: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
3740: l_item_type WF_ITEMS.item_type%TYPE;
3741: l_item_key WF_ITEMS.item_key%TYPE;
3742: l_firstcolon NUMBER;
3743: l_secondcolon NUMBER;
3744: l_itemtype WF_ITEMS.item_type%TYPE;
3745: l_itemkey WF_ITEMS.item_key%TYPE;

Line 3744: l_itemtype WF_ITEMS.item_type%TYPE;

3740: l_item_type WF_ITEMS.item_type%TYPE;
3741: l_item_key WF_ITEMS.item_key%TYPE;
3742: l_firstcolon NUMBER;
3743: l_secondcolon NUMBER;
3744: l_itemtype WF_ITEMS.item_type%TYPE;
3745: l_itemkey WF_ITEMS.item_key%TYPE;
3746:
3747: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'get_sign_notfn_body';
3748: d_position NUMBER;

Line 3745: l_itemkey WF_ITEMS.item_key%TYPE;

3741: l_item_key WF_ITEMS.item_key%TYPE;
3742: l_firstcolon NUMBER;
3743: l_secondcolon NUMBER;
3744: l_itemtype WF_ITEMS.item_type%TYPE;
3745: l_itemkey WF_ITEMS.item_key%TYPE;
3746:
3747: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'get_sign_notfn_body';
3748: d_position NUMBER;
3749: BEGIN

Line 4482: l_itemtype WF_ITEMS.item_type%TYPE;

4478: l_progress VARCHAR2(300);
4479: l_document_id NUMBER;
4480: l_firstcolon NUMBER;
4481: l_secondcolon NUMBER;
4482: l_itemtype WF_ITEMS.item_type%TYPE;
4483: l_pdf_type VARCHAR2(50);
4484:
4485: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'get_closeout_pdf';
4486: d_position NUMBER;