DBA Data[Home] [Help]

APPS.HR_UTIL_MISC_SS dependencies on FND_FORM_FUNCTIONS

Line 408: l_function_name fnd_form_functions.function_name%Type;

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

Line 413: FROM fnd_form_functions fff

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

Line 625: l_function_name fnd_form_functions.function_name%Type;

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')

Line 636: FROM fnd_form_functions fff

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

Line 1390: FROM fnd_form_functions fff

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:

Line 2726: select 'X' into dummy from fnd_form_functions where function_name = fn_name

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:

Line 2745: select 'X' into dummy from fnd_form_functions where function_name = fn_name

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:

Line 2767: select 'X' into dummy from fnd_form_functions where function_name = fn_name

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: