DBA Data[Home] [Help]

APPS.PO_CHG_REQUEST_PVT dependencies on WF_ITEMS

Line 2907: l_item_key WF_ITEMS.item_key%TYPE := NULL;

2903: IS
2904:
2905: l_api_version_number CONSTANT NUMBER := 1.0;
2906: l_api_name CONSTANT VARCHAR2(30) := 'process_supplier_signature';
2907: l_item_key WF_ITEMS.item_key%TYPE := NULL;
2908: l_item_type WF_ITEMS.item_type%TYPE;
2909: x_result VARCHAR2(20);
2910: x_sup_user_id NUMBER;
2911: l_supplier_username fnd_user.user_name%type;

Line 2908: l_item_type WF_ITEMS.item_type%TYPE;

2904:
2905: l_api_version_number CONSTANT NUMBER := 1.0;
2906: l_api_name CONSTANT VARCHAR2(30) := 'process_supplier_signature';
2907: l_item_key WF_ITEMS.item_key%TYPE := NULL;
2908: l_item_type WF_ITEMS.item_type%TYPE;
2909: x_result VARCHAR2(20);
2910: x_sup_user_id NUMBER;
2911: l_supplier_username fnd_user.user_name%type;
2912: sig_notif_notfound exception;

Line 3130: l_item_key WF_ITEMS.item_key%TYPE := NULL;

3126: IS
3127:
3128: l_api_version_number CONSTANT NUMBER := 1.0;
3129: l_api_name CONSTANT VARCHAR2(30) := 'process_supplier_signature';
3130: l_item_key WF_ITEMS.item_key%TYPE := NULL;
3131: l_item_type WF_ITEMS.item_type%TYPE;
3132: x_result VARCHAR2(20);
3133: x_sup_user_id NUMBER;
3134: l_supplier_username fnd_user.user_name%type;

Line 3131: l_item_type WF_ITEMS.item_type%TYPE;

3127:
3128: l_api_version_number CONSTANT NUMBER := 1.0;
3129: l_api_name CONSTANT VARCHAR2(30) := 'process_supplier_signature';
3130: l_item_key WF_ITEMS.item_key%TYPE := NULL;
3131: l_item_type WF_ITEMS.item_type%TYPE;
3132: x_result VARCHAR2(20);
3133: x_sup_user_id NUMBER;
3134: l_supplier_username fnd_user.user_name%type;
3135: sig_notif_notfound exception;