DBA Data[Home] [Help]

APPS.ICX_SEC dependencies on FND_FORM_FUNCTIONS

Line 1150: from FND_FORM_FUNCTIONS

1146: if l_responsibility_id = -1
1147: then
1148: select FUNCTION_ID
1149: into l_function_id
1150: from FND_FORM_FUNCTIONS
1151: where FUNCTION_ID = l_entry_sequence
1152: and FUNCTION_NAME = 'ICX_NAVIGATE_PLUG';
1153:
1154: l_responsibility_id := '';

Line 1165: from FND_FORM_FUNCTIONS fff,

1161: into l_resp_appl_id,
1162: l_security_group_id,
1163: l_responsibility_id,
1164: l_function_id
1165: from FND_FORM_FUNCTIONS fff,
1166: FND_MENU_ENTRIES fme,
1167: ICX_PAGE_PLUGS ipe
1168: where ipe.PLUG_ID = p_plug_id
1169: and fme.MENU_ID = ipe.MENU_ID

Line 3584: from FND_FORM_FUNCTIONS

3580: if p_function_id is null
3581: then
3582: select FUNCTION_ID
3583: into l_function_id
3584: from FND_FORM_FUNCTIONS
3585: where FUNCTION_NAME = p_function_name;
3586: else
3587: l_function_id := p_function_id;
3588: end if;

Line 3718: from FND_FORM_FUNCTIONS

3714: if p_function_id is null and p_function_name is not null
3715: then
3716: select FUNCTION_ID, TYPE
3717: into l_function_id, l_function_type
3718: from FND_FORM_FUNCTIONS
3719: where FUNCTION_NAME = p_function_name;
3720: elsif p_function_name is null and p_function_id is not null
3721: then
3722: select FUNCTION_ID, TYPE

Line 3724: from FND_FORM_FUNCTIONS

3720: elsif p_function_name is null and p_function_id is not null
3721: then
3722: select FUNCTION_ID, TYPE
3723: into l_function_id, l_function_type
3724: from FND_FORM_FUNCTIONS
3725: where FUNCTION_ID = p_function_id;
3726: else
3727: l_function_id := '';
3728: l_function_type := '';

Line 3837: from fnd_form_functions

3833: begin
3834:
3835: select web_host_name,web_agent_name,web_html_call,web_encrypt_parameters
3836: into l_web_host_name,l_web_agent_name,l_web_html_call,l_web_encrypt_parameters
3837: from fnd_form_functions
3838: where FUNCTION_NAME = p_function_code
3839: and WEB_SECURED = 'Y';
3840:
3841: l_url := '';

Line 4442: from FND_FORM_FUNCTIONS a,

4438:
4439: END IF;
4440: select count(*)
4441: INTO n_hits
4442: from FND_FORM_FUNCTIONS a,
4443: fnd_menu_entries_vl b,
4444: fnd_responsibility_vl c,
4445: fnd_user_resp_groups d,
4446: fnd_security_groups_vl e