APPS.ORACLEAPPS dependencies on FND_FORM_FUNCTIONS

Line 140: from fnd_form_functions

136: where SESSION_ID = n_session_id;
137:
138: select function_id
139: into l_function_id
140: from fnd_form_functions
141: where function_name = i_3;
142:
143: runFunction( l_function_id, n_session_id);
144: end if;

Line 487: from fnd_form_functions fff

483: i_4 := n_session_id;
484:
485: select fff.function_id
486: into l_function_id
487: from fnd_form_functions fff
488: where fff.function_name = i_3;
489:
490: update icx_sessions
491: set responsibility_id = NULL,

Line 1167: from fnd_form_functions

1163:
1164:
1165: cursor getFunctionId(p_function_name in varchar2) is
1166: select function_id
1167: from fnd_form_functions
1168: where function_name = p_function_name;
1169:
1170: begin
1171:

Line 1444: f fnd_form_functions_vl%rowtype;

1440: l_count number;
1441: l_function_id number;
1442:
1443: -- added to suport menu
1444: f fnd_form_functions_vl%rowtype;
1445: l_menuItems menuItemTable;
1446: l_level number;
1447: l_encrypt_menu varchar2(2000);
1448: l_user_menu_name varchar2(80);

Line 1484: from fnd_form_functions c,

1480: c.web_html_call,
1481: b.prompt,
1482: b.description,
1483: c.web_icon
1484: from fnd_form_functions c,
1485: fnd_menu_entries_vl b
1486: where b.menu_id = c_menu_id
1487: and c.function_id(+) = b.function_id
1488: and nvl(c.type,'WWW') in ('WWW','WWK', 'SERVLET','JSP', 'INTEROPJSP')

Line 1887: f fnd_form_functions_vl%rowtype;

1883: c_display_error varchar2(240);
1884: n_error_num number;
1885:
1886: -- non scalar type
1887: f fnd_form_functions_vl%rowtype;
1888: p_funcTable icx_admin_sig.pp_table;
1889: p_funcEmpty icx_admin_sig.pp_table;
1890: l_prompt varchar2(30);
1891: l_description varchar2(240);

Line 1902: from fnd_form_functions b,

1898: b.web_html_call,
1899: a.prompt,
1900: a.description,
1901: b.web_icon
1902: from fnd_form_functions b,
1903: fnd_menu_entries_vl a
1904: where a.menu_id = l_menu_id
1905: and a.function_id = b.function_id(+)
1906: order by a.entry_sequence;

Line 2442: from FND_FORM_FUNCTIONS

2438: l_function_type := '';
2439: else
2440: select TYPE
2441: into l_function_type
2442: from FND_FORM_FUNCTIONS
2443: where FUNCTION_ID = l_function_id;
2444: end if;
2445: l_menu_id := l_parameters(5);
2446:

Line 2528: f fnd_form_functions%rowtype;

2524: p_menu_id in NUMBER,
2525: p_function_type in VARCHAR2,
2526: p_page_id in NUMBER) is
2527:
2528: f fnd_form_functions%rowtype;
2529: c_procedure_call varchar2(2000);
2530: c_anchor varchar2(2000);
2531: l_dbc varchar2(240);
2532: l_message varchar2(240);

Line 2573: from fnd_form_functions

2569:
2570: begin
2571:
2572: select * into f
2573: from fnd_form_functions
2574: where function_id = c_function_id;
2575:
2576: /* bug 1142377, f.PARAMETERS may contain spaces.
2577: if f.PARAMETERS is not null and c_parameters is null

Line 2997: from fnd_form_functions_vl c,

2993: cursor functions is
2994: select user_function_name,description,
2995: web_HOST_NAME,web_AGENT_NAME,web_HTML_CALL,
2996: PARAMETERS
2997: from fnd_form_functions_vl c,
2998: fnd_resp_functions a
2999: where c_responsibility_id = a.responsibility_id
3000: and a.action_id = c.function_id
3001: order by user_function_name;