DBA Data[Home] [Help]

APPS.FND_IREP_LOADER_PRIVATE dependencies on FND_FORM_FUNCTIONS_TL

Line 25: type t_fnd_form_functions_tl IS TABLE OF fnd_form_functions_tl % rowtype;

21: menu_id fnd_menus.menu_id%TYPE;
22:
23: type t_fnd_menus_tl IS TABLE OF fnd_menus_tl % rowtype;
24: type t_fnd_menu_entries_tl IS TABLE OF fnd_menu_entries_tl % rowtype;
25: type t_fnd_form_functions_tl IS TABLE OF fnd_form_functions_tl % rowtype;
26:
27:
28: -- to store existing menus and grants
29: v_fnd_grants t_fnd_grants;

Line 1070: update FND_FORM_FUNCTIONS_TL

1066: where c.class_name = P_OBJECT_NAME
1067: and f.irep_class_id = c.class_id
1068: and f.function_name = P_FUNCTION_NAME;
1069:
1070: update FND_FORM_FUNCTIONS_TL
1071: set source_lang=userenv('LANG'),
1072: USER_FUNCTION_NAME = nvl(P_USER_FN_NAME, USER_FUNCTION_NAME),
1073: DESCRIPTION = nvl(P_SHORT_DESCRIPTION, DESCRIPTION),
1074: last_updated_by = f_luby,

Line 1126: Insert into FND_FORM_FUNCTIONS_TL

1122: P_METHOD_NAME, P_OVERLOAD_SEQ, nice_scope,
1123: nice_lifecy, P_DESCRIPTION,
1124: nice_compat, nice_synch, nice_direct);
1125:
1126: Insert into FND_FORM_FUNCTIONS_TL
1127: (FUNCTION_ID, USER_FUNCTION_NAME, DESCRIPTION, language,
1128: source_lang, last_update_date, last_updated_by,
1129: created_by, creation_date, last_update_login
1130: ) select

Line 1137: from FND_FORM_FUNCTIONS_TL t

1133: from fnd_languages l
1134: where l.installed_flag in ('I','B')
1135: and not exists
1136: (select null
1137: from FND_FORM_FUNCTIONS_TL t
1138: where t.FUNCTION_ID = fn_id
1139: and t.language = l.language_code);
1140:
1141: -- Restore earlier saved grants

Line 1193: UPDATE FND_FORM_FUNCTIONS_TL

1189: UPDATE FND_FORM_FUNCTIONS
1190: SET IREP_DESCRIPTION = P_DESCRIPTION
1191: WHERE FUNCTION_ID = fn_id;
1192:
1193: UPDATE FND_FORM_FUNCTIONS_TL
1194: SET USER_FUNCTION_NAME = P_USER_FN_NAME,
1195: DESCRIPTION = P_SHORT_DESCRIPTION,
1196: last_update_date = f_ludate,
1197: last_updated_by = f_luby,

Line 1404: Insert into FND_FORM_FUNCTIONS_TL (

1400: EXIT WHEN (SQL%ROWCOUNT=0);
1401: END LOOP;
1402:
1403: /* Insert TL shadow rows (for newly created base rows) */
1404: Insert into FND_FORM_FUNCTIONS_TL (
1405: FUNCTION_ID, USER_FUNCTION_NAME,
1406: DESCRIPTION, language,
1407: source_lang, last_update_date,
1408: last_updated_by, created_by,

Line 1420: fnd_form_functions_tl parent_tl

1416: fnd_irep_classes parent_c,
1417: fnd_irep_classes child_c,
1418: fnd_form_functions parent_m,
1419: fnd_form_functions child_m,
1420: fnd_form_functions_tl parent_tl
1421: where ass.Parent_class_name = Parent_c.class_name
1422: and ass.Class_name = Child_c.class_name
1423: and parent_m.irep_class_id = parent_c.class_id
1424: and child_m.irep_class_id = child_c.class_id

Line 1430: from fnd_form_functions_tl child_tl

1426: child_c.class_name || ':' || parent_m.irep_method_name
1427: and parent_tl.function_id = parent_m.function_id
1428: and not exists (
1429: select 1
1430: from fnd_form_functions_tl child_tl
1431: where child_tl.function_id = child_m.function_id
1432: and child_tl.source_lang = parent_tl.source_lang
1433: and child_tl.language = parent_tl.language);
1434: