APPS.OKC_REP_WF_PVT dependencies on WF_ITEMS

Line 497: l_item_key wf_items.item_key%TYPE;

493: l_item_sources ame_util.longStringList;
494: l_user_name varchar2(4000);
495: l_role_name varchar2(4000);
496: l_role_display_name varchar2(4000);
497: l_item_key wf_items.item_key%TYPE;
498: l_notified_count number;
499:
500: l_approver_name VARCHAR2(100);
501: l_approver_type VARCHAR2(100);

Line 2435: SELECT item_key FROM wf_items

2431: l_item_sources ame_util.longStringList;
2432: l_user_names varchar2(4000);
2433:
2434: CURSOR wf_process_csr IS
2435: SELECT item_key FROM wf_items
2436: WHERE item_type=itemtype
2437: AND item_key like itemkey || '_' || '%'
2438: and end_date is null;
2439:

Line 2626: l_master_key wf_items.user_key%TYPE;

2622: l_api_name VARCHAR2(30);
2623: l_return_status VARCHAR2(1);
2624: l_msg_count NUMBER;
2625: l_msg_data VARCHAR2(2000);
2626: l_master_key wf_items.user_key%TYPE;
2627:
2628: BEGIN
2629:
2630: l_api_name := 'complete_notification';

Line 2720: l_master_key wf_items.user_key%TYPE;

2716: l_api_name VARCHAR2(30);
2717: l_return_status VARCHAR2(1);
2718: l_msg_count NUMBER;
2719: l_msg_data VARCHAR2(2000);
2720: l_master_key wf_items.user_key%TYPE;
2721: l_value VARCHAR2(1);
2722:
2723:
2724: BEGIN

Line 2812: l_master_key wf_items.user_key%TYPE;

2808: l_api_name VARCHAR2(30);
2809: l_return_status VARCHAR2(1);
2810: l_msg_count NUMBER;
2811: l_msg_data VARCHAR2(2000);
2812: l_master_key wf_items.user_key%TYPE;
2813: l_value VARCHAR2(1);
2814:
2815: CURSOR contract_attachment_exists(l_contract_id IN NUMBER,l_contract_type IN VARCHAR2, l_con_req_id IN NUMBER) IS
2816: select 'Y'

Line 2978: l_master_key wf_items.user_key%TYPE;

2974: l_api_name VARCHAR2(30);
2975: l_return_status VARCHAR2(1);
2976: l_msg_count NUMBER;
2977: l_msg_data VARCHAR2(2000);
2978: l_master_key wf_items.user_key%TYPE;
2979: l_value VARCHAR2(1);
2980:
2981: CURSOR csr_doc(l_contract_type IN VARCHAR2) IS
2982: SELECT Nvl(ALLOW_APPROVER_EDIT_YN,'N') FROM okc_bus_doc_types_b WHERE document_type=l_contract_type;

Line 3062: l_master_key wf_items.user_key%TYPE;

3058: l_api_name VARCHAR2(30);
3059: l_return_status VARCHAR2(1);
3060: l_msg_count NUMBER;
3061: l_msg_data VARCHAR2(2000);
3062: l_master_key wf_items.user_key%TYPE;
3063: l_value VARCHAR2(1);
3064:
3065: CURSOR csr_doc(l_contract_type IN VARCHAR2) IS
3066: SELECT Nvl(ALLOW_APPROVER_EDIT_YN,'N') FROM okc_bus_doc_types_b WHERE document_type=l_contract_type;