APPS.BSC_LAUNCH_PAD_PVT dependencies on FND_FORM_FUNCTIONS_VL

Line 348: FROM FND_FORM_FUNCTIONS_VL

344: BEGIN
345: -- Name
346: SELECT count(*)
347: INTO h_count
348: FROM FND_FORM_FUNCTIONS_VL
349: WHERE FUNCTION_ID <> X_FUNCTION_ID
350: AND (FUNCTION_NAME = X_FUNCTION_NAME);
351: IF h_count > 0 THEN
352: h_val := 'N';

Line 358: FROM FND_FORM_FUNCTIONS_VL

354: END IF;
355: -- User Name
356: SELECT count(*)
357: INTO h_count
358: FROM FND_FORM_FUNCTIONS_VL
359: WHERE FUNCTION_ID <> X_FUNCTION_ID
360: AND (USER_FUNCTION_NAME = X_USER_FUNCTION_NAME);
361: IF h_count > 0 THEN
362: h_val := 'U';

Line 631: FROM fnd_form_functions_vl

627: WHERE function_name = h_function_name;
628:
629: CURSOR c_function_id_u IS
630: SELECT function_id
631: FROM fnd_form_functions_vl
632: WHERE user_function_name = h_user_function_name;
633:
634: h_function_id NUMBER;
635: h_web_host_name VARCHAR2(80);

Line 758: ' FROM FND_MENU_ENTRIES@'||x_src_db_link||' SE, FND_FORM_FUNCTIONS_VL@'||x_src_db_link||' SF'||

754: -- and are not associated with the same menu in the target system.
755: -- We need to create those entries in the target menu.
756: -- Only see BSC functions
757: h_sql := 'SELECT SF.FUNCTION_NAME, SF.USER_FUNCTION_NAME, SF.FUNCTION_ID'||
758: ' FROM FND_MENU_ENTRIES@'||x_src_db_link||' SE, FND_FORM_FUNCTIONS_VL@'||x_src_db_link||' SF'||
759: ' WHERE SE.MENU_ID = :1 AND SE.FUNCTION_ID = SF.FUNCTION_ID AND'||
760: ' SF.APPLICATION_ID = 271 AND SF.FUNCTION_NAME NOT IN ('||
761: ' SELECT TF.FUNCTION_NAME FROM FND_MENU_ENTRIES TE, FND_FORM_FUNCTIONS TF'||
762: ' WHERE TE.MENU_ID = :2 AND TE.FUNCTION_ID = TF.FUNCTION_ID AND TF.APPLICATION_ID = 271)';

Line 823: ' FROM fnd_form_functions_vl@'||x_src_db_link||

819: h_sql := 'SELECT web_host_name, web_agent_name, web_html_call,'||
820: ' web_encrypt_parameters, web_secured, web_icon, object_id,'||
821: ' region_application_id, region_code, application_id,'||
822: ' form_id, parameters, type, description'||
823: ' FROM fnd_form_functions_vl@'||x_src_db_link||
824: ' WHERE function_name = :1';
825: /*' WHERE function_name = '''||h_function_name||'''';*/
826:
827: h_cursor2 := DBMS_SQL.OPEN_CURSOR;