APPS.OKC_REP_SIGN_WF_PVT dependencies on WF_ITEMS

Line 306: SELECT owner_role from wf_items wf WHERE wf.item_type=itemtype AND wf.item_key=itemkey;

302: ) IS
303:
304:
305: CURSOR get_owner is
306: SELECT owner_role from wf_items wf WHERE wf.item_type=itemtype AND wf.item_key=itemkey;
307:
308: l_api_name varchar2(30);
309: l_contract_id OKC_REP_CONTRACTS_ALL.contract_id%type;
310: l_contract_number OKC_REP_CONTRACTS_ALL.contract_number%type;

Line 320: l_item_key wf_items.item_key%TYPE;

316: l_process_complete_yn varchar2(1);
317: l_user_name varchar2(4000);
318: l_role_name varchar2(4000);
319: l_role_display_name varchar2(4000);
320: l_item_key wf_items.item_key%TYPE;
321: l_notified_count number;
322: l_next_signers SIGNERS_TBL_TYPE;
323: l_contract_hdr_token VARCHAR2(50);
324: l_owner VARCHAR2(50);

Line 930: l_master_key wf_items.item_key%TYPE;

926: AND wfn.notification_id = p_notification_id ;
927:
928: notif_rec notif_csr%ROWTYPE;
929: l_sequence_id NUMBER;
930: l_master_key wf_items.item_key%TYPE;
931: l_contact_id NUMBER;
932: l_party_id NUMBER;
933: l_party_role_code VARCHAR2(50);
934:

Line 942: SELECT Count(item_key) FROM wf_items

938: l_upd_cont_num_suc_yn VARCHAR2(1) := 'Y';
939: l_exist_id NUMBER;
940:
941: CURSOR wf_process_csr(p_master_key IN VARCHAR2) IS
942: SELECT Count(item_key) FROM wf_items
943: WHERE item_type=itemtype
944: AND item_key like p_master_key || '!_' || '%' ESCAPE '!'
945: and end_date is null;
946:

Line 1833: l_master_key wf_items.user_key%TYPE;

1829: l_api_name VARCHAR2(30);
1830: l_return_status VARCHAR2(1);
1831: l_msg_count NUMBER;
1832: l_msg_data VARCHAR2(2000);
1833: l_master_key wf_items.user_key%TYPE;
1834: l_value VARCHAR2(1);
1835:
1836:
1837: BEGIN

Line 1926: l_master_key wf_items.user_key%TYPE;

1922: l_api_name VARCHAR2(30);
1923: l_return_status VARCHAR2(1);
1924: l_msg_count NUMBER;
1925: l_msg_data VARCHAR2(2000);
1926: l_master_key wf_items.user_key%TYPE;
1927: l_value VARCHAR2(1);
1928:
1929: CURSOR contract_attachment_exists(l_contract_id IN NUMBER,l_contract_type IN VARCHAR2, l_con_req_id IN NUMBER) IS
1930: select 'Y'

Line 2025: l_master_key wf_items.user_key%TYPE;

2021: l_api_name VARCHAR2(30);
2022: l_return_status VARCHAR2(1);
2023: l_msg_count NUMBER;
2024: l_msg_data VARCHAR2(2000);
2025: l_master_key wf_items.user_key%TYPE;
2026: l_value VARCHAR2(1);
2027:
2028: CURSOR csr_doc(l_contract_type IN VARCHAR2) IS
2029: SELECT Nvl(ALLOW_APPROVER_EDIT_YN,'N') FROM okc_bus_doc_types_b WHERE document_type=l_contract_type;