404: l_proc varchar2(72) := g_package||' check_term_access';
405: l_status VARCHAR2(10):= 'N';
406: l_item_type hr_api_transactions.item_type%type;
407: l_temp VARCHAR2(100);
408: l_function_name fnd_form_functions.function_name%Type;
409:
410: -- Local Cursors
411: CURSOR csr_fnd_func_details (p_func_name VARCHAR2)IS
412: SELECT function_id, parameters, web_html_call
409:
410: -- Local Cursors
411: CURSOR csr_fnd_func_details (p_func_name VARCHAR2)IS
412: SELECT function_id, parameters, web_html_call
413: FROM fnd_form_functions fff
414: WHERE fff.function_name = p_func_name;
415:
416:
417: CURSOR csr_wf_process (p_wfpname VARCHAR2, p_item_type VARCHAR2) IS
621: l_status VARCHAR2(10):= 'C';
622: l_npw_status VARCHAR2(30);
623: l_item_type hr_api_transactions.item_type%type;
624: l_temp VARCHAR2(100);
625: l_function_name fnd_form_functions.function_name%Type;
626:
627: -- Local Cursors
628: CURSOR csr_per_npw_flag IS
629: SELECT nvl(current_npw_flag,'N')
632: AND p_eff_date BETWEEN per.effective_start_date AND per.effective_end_date;
633:
634: CURSOR csr_fnd_func_details (p_func_name VARCHAR2)IS
635: SELECT function_id, parameters, web_html_call
636: FROM fnd_form_functions fff
637: WHERE fff.function_name = p_func_name;
638:
639: CURSOR csr_menu_entries (p_menu_name VARCHAR2, p_func_id NUMBER) IS
640: select 'T' from fnd_menus m, fnd_menu_entries me
1386: l_ghr_index number default 0;
1387:
1388: CURSOR csr_fnd_func_details IS
1389: SELECT function_name ,parameters, web_html_call
1390: FROM fnd_form_functions fff
1391: WHERE fff.function_id = p_function_id;
1392:
1393: l_func_details csr_fnd_func_details%ROWTYPE;
1394:
2722: dummy VARCHAR2(10);
2723: begin
2724:
2725:
2726: select 'X' into dummy from fnd_form_functions where function_name = fn_name
2727: and parameters like '%pQkFn=Y%';
2728:
2729: dummy := null;
2730:
2741:
2742: dummy VARCHAR2(10);
2743: begin
2744:
2745: select 'X' into dummy from fnd_form_functions where function_name = fn_name
2746: and parameters like '%pBpRv=Y%';
2747:
2748: dummy := null;
2749:
2763:
2764: begin
2765:
2766:
2767: select 'X' into dummy from fnd_form_functions where function_name = fn_name
2768: and parameters like '%pEffectiveDate=%';
2769:
2770: dummy := null;
2771: