DBA Data[Home] [Help]

APPS.JTF_MENU_PUB dependencies on FND_FORM_FUNCTIONS

Line 11: web_host_name fnd_form_functions_vl.web_host_name%type, -- varchar2(80),

7: -- =======================================================================
8: -- Types and Constants
9: -- =======================================================================
10: TYPE function_data is record(
11: web_host_name fnd_form_functions_vl.web_host_name%type, -- varchar2(80),
12: web_agent_name fnd_form_functions_vl.web_agent_name%type, -- varchar2(80),
13: web_html_call fnd_form_functions_vl.web_html_call%type, -- varchar2(240),
14: web_encrypt_parameters fnd_form_functions_vl.web_encrypt_parameters%type, -- varchar2(1),
15: web_secured fnd_form_functions_vl.web_secured%type, -- varchar2(1),

Line 12: web_agent_name fnd_form_functions_vl.web_agent_name%type, -- varchar2(80),

8: -- Types and Constants
9: -- =======================================================================
10: TYPE function_data is record(
11: web_host_name fnd_form_functions_vl.web_host_name%type, -- varchar2(80),
12: web_agent_name fnd_form_functions_vl.web_agent_name%type, -- varchar2(80),
13: web_html_call fnd_form_functions_vl.web_html_call%type, -- varchar2(240),
14: web_encrypt_parameters fnd_form_functions_vl.web_encrypt_parameters%type, -- varchar2(1),
15: web_secured fnd_form_functions_vl.web_secured%type, -- varchar2(1),
16: web_icon fnd_form_functions_vl.web_icon%type, -- varchar2(30),

Line 13: web_html_call fnd_form_functions_vl.web_html_call%type, -- varchar2(240),

9: -- =======================================================================
10: TYPE function_data is record(
11: web_host_name fnd_form_functions_vl.web_host_name%type, -- varchar2(80),
12: web_agent_name fnd_form_functions_vl.web_agent_name%type, -- varchar2(80),
13: web_html_call fnd_form_functions_vl.web_html_call%type, -- varchar2(240),
14: web_encrypt_parameters fnd_form_functions_vl.web_encrypt_parameters%type, -- varchar2(1),
15: web_secured fnd_form_functions_vl.web_secured%type, -- varchar2(1),
16: web_icon fnd_form_functions_vl.web_icon%type, -- varchar2(30),
17: function_id fnd_form_functions_vl.function_id%type, -- number,

Line 14: web_encrypt_parameters fnd_form_functions_vl.web_encrypt_parameters%type, -- varchar2(1),

10: TYPE function_data is record(
11: web_host_name fnd_form_functions_vl.web_host_name%type, -- varchar2(80),
12: web_agent_name fnd_form_functions_vl.web_agent_name%type, -- varchar2(80),
13: web_html_call fnd_form_functions_vl.web_html_call%type, -- varchar2(240),
14: web_encrypt_parameters fnd_form_functions_vl.web_encrypt_parameters%type, -- varchar2(1),
15: web_secured fnd_form_functions_vl.web_secured%type, -- varchar2(1),
16: web_icon fnd_form_functions_vl.web_icon%type, -- varchar2(30),
17: function_id fnd_form_functions_vl.function_id%type, -- number,
18: function_name fnd_form_functions_vl.function_name%type, -- varchar2(30),

Line 15: web_secured fnd_form_functions_vl.web_secured%type, -- varchar2(1),

11: web_host_name fnd_form_functions_vl.web_host_name%type, -- varchar2(80),
12: web_agent_name fnd_form_functions_vl.web_agent_name%type, -- varchar2(80),
13: web_html_call fnd_form_functions_vl.web_html_call%type, -- varchar2(240),
14: web_encrypt_parameters fnd_form_functions_vl.web_encrypt_parameters%type, -- varchar2(1),
15: web_secured fnd_form_functions_vl.web_secured%type, -- varchar2(1),
16: web_icon fnd_form_functions_vl.web_icon%type, -- varchar2(30),
17: function_id fnd_form_functions_vl.function_id%type, -- number,
18: function_name fnd_form_functions_vl.function_name%type, -- varchar2(30),
19: application_id fnd_form_functions_vl.application_id%type, -- number,

Line 16: web_icon fnd_form_functions_vl.web_icon%type, -- varchar2(30),

12: web_agent_name fnd_form_functions_vl.web_agent_name%type, -- varchar2(80),
13: web_html_call fnd_form_functions_vl.web_html_call%type, -- varchar2(240),
14: web_encrypt_parameters fnd_form_functions_vl.web_encrypt_parameters%type, -- varchar2(1),
15: web_secured fnd_form_functions_vl.web_secured%type, -- varchar2(1),
16: web_icon fnd_form_functions_vl.web_icon%type, -- varchar2(30),
17: function_id fnd_form_functions_vl.function_id%type, -- number,
18: function_name fnd_form_functions_vl.function_name%type, -- varchar2(30),
19: application_id fnd_form_functions_vl.application_id%type, -- number,
20: creation_date fnd_form_functions_vl.creation_date%type, -- date,

Line 17: function_id fnd_form_functions_vl.function_id%type, -- number,

13: web_html_call fnd_form_functions_vl.web_html_call%type, -- varchar2(240),
14: web_encrypt_parameters fnd_form_functions_vl.web_encrypt_parameters%type, -- varchar2(1),
15: web_secured fnd_form_functions_vl.web_secured%type, -- varchar2(1),
16: web_icon fnd_form_functions_vl.web_icon%type, -- varchar2(30),
17: function_id fnd_form_functions_vl.function_id%type, -- number,
18: function_name fnd_form_functions_vl.function_name%type, -- varchar2(30),
19: application_id fnd_form_functions_vl.application_id%type, -- number,
20: creation_date fnd_form_functions_vl.creation_date%type, -- date,
21: type fnd_form_functions_vl.type%type, -- varchar2(30),

Line 18: function_name fnd_form_functions_vl.function_name%type, -- varchar2(30),

14: web_encrypt_parameters fnd_form_functions_vl.web_encrypt_parameters%type, -- varchar2(1),
15: web_secured fnd_form_functions_vl.web_secured%type, -- varchar2(1),
16: web_icon fnd_form_functions_vl.web_icon%type, -- varchar2(30),
17: function_id fnd_form_functions_vl.function_id%type, -- number,
18: function_name fnd_form_functions_vl.function_name%type, -- varchar2(30),
19: application_id fnd_form_functions_vl.application_id%type, -- number,
20: creation_date fnd_form_functions_vl.creation_date%type, -- date,
21: type fnd_form_functions_vl.type%type, -- varchar2(30),
22: user_function_name fnd_form_functions_vl.user_function_name%type, -- varchar2(80),

Line 19: application_id fnd_form_functions_vl.application_id%type, -- number,

15: web_secured fnd_form_functions_vl.web_secured%type, -- varchar2(1),
16: web_icon fnd_form_functions_vl.web_icon%type, -- varchar2(30),
17: function_id fnd_form_functions_vl.function_id%type, -- number,
18: function_name fnd_form_functions_vl.function_name%type, -- varchar2(30),
19: application_id fnd_form_functions_vl.application_id%type, -- number,
20: creation_date fnd_form_functions_vl.creation_date%type, -- date,
21: type fnd_form_functions_vl.type%type, -- varchar2(30),
22: user_function_name fnd_form_functions_vl.user_function_name%type, -- varchar2(80),
23: description fnd_form_functions_vl.description%type -- varchar2(240)

Line 20: creation_date fnd_form_functions_vl.creation_date%type, -- date,

16: web_icon fnd_form_functions_vl.web_icon%type, -- varchar2(30),
17: function_id fnd_form_functions_vl.function_id%type, -- number,
18: function_name fnd_form_functions_vl.function_name%type, -- varchar2(30),
19: application_id fnd_form_functions_vl.application_id%type, -- number,
20: creation_date fnd_form_functions_vl.creation_date%type, -- date,
21: type fnd_form_functions_vl.type%type, -- varchar2(30),
22: user_function_name fnd_form_functions_vl.user_function_name%type, -- varchar2(80),
23: description fnd_form_functions_vl.description%type -- varchar2(240)
24: );

Line 21: type fnd_form_functions_vl.type%type, -- varchar2(30),

17: function_id fnd_form_functions_vl.function_id%type, -- number,
18: function_name fnd_form_functions_vl.function_name%type, -- varchar2(30),
19: application_id fnd_form_functions_vl.application_id%type, -- number,
20: creation_date fnd_form_functions_vl.creation_date%type, -- date,
21: type fnd_form_functions_vl.type%type, -- varchar2(30),
22: user_function_name fnd_form_functions_vl.user_function_name%type, -- varchar2(80),
23: description fnd_form_functions_vl.description%type -- varchar2(240)
24: );
25:

Line 22: user_function_name fnd_form_functions_vl.user_function_name%type, -- varchar2(80),

18: function_name fnd_form_functions_vl.function_name%type, -- varchar2(30),
19: application_id fnd_form_functions_vl.application_id%type, -- number,
20: creation_date fnd_form_functions_vl.creation_date%type, -- date,
21: type fnd_form_functions_vl.type%type, -- varchar2(30),
22: user_function_name fnd_form_functions_vl.user_function_name%type, -- varchar2(80),
23: description fnd_form_functions_vl.description%type -- varchar2(240)
24: );
25:
26: cursor get_app_menu(p_menuid number) is

Line 23: description fnd_form_functions_vl.description%type -- varchar2(240)

19: application_id fnd_form_functions_vl.application_id%type, -- number,
20: creation_date fnd_form_functions_vl.creation_date%type, -- date,
21: type fnd_form_functions_vl.type%type, -- varchar2(30),
22: user_function_name fnd_form_functions_vl.user_function_name%type, -- varchar2(80),
23: description fnd_form_functions_vl.description%type -- varchar2(240)
24: );
25:
26: cursor get_app_menu(p_menuid number) is
27: select a.sub_menu_id , prompt,description,function_id,menu_name

Line 36: from fnd_form_functions_vl

32: select web_host_name, web_agent_name,web_html_call,
33: web_encrypt_parameters, web_secured,
34: web_icon,function_id, function_name,application_id, creation_date,type,
35: user_function_name, description
36: from fnd_form_functions_vl
37: where function_id = p_functionid;
38:
39: -- this private function is the basis of 'menu exclusion' functionality.
40: -- (this functionality used to be done only in the Java layer, but

Line 609: -- from fnd_form_functions_vl

605:
606: -- the old SELECT statement
607: -- cursor get_func_name(p_func_id number) is
608: -- select user_function_name
609: -- from fnd_form_functions_vl
610: -- where function_id = p_func_id;
611: cursor get_func_name(p_func_id number, pp_lang varchar2) is
612: SELECT
613: T.USER_FUNCTION_NAME

Line 614: FROM FND_FORM_FUNCTIONS_TL T, FND_FORM_FUNCTIONS B

610: -- where function_id = p_func_id;
611: cursor get_func_name(p_func_id number, pp_lang varchar2) is
612: SELECT
613: T.USER_FUNCTION_NAME
614: FROM FND_FORM_FUNCTIONS_TL T, FND_FORM_FUNCTIONS B
615: WHERE B.FUNCTION_ID = T.FUNCTION_ID AND T.LANGUAGE = pp_lang and
616: b.function_id = p_func_id;
617: begin
618: if p_lang is null then

Line 639: from fnd_form_functions_vl

635: l_function_name varchar2(80);
636:
637: cursor get_func_name(p_func_id number) is
638: select user_function_name
639: from fnd_form_functions_vl
640: where function_id = p_func_id;
641:
642: BEGIN
643: open get_func_name(p_function_id);