eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_MIGRATION dependencies on FND_FORM_FUNCTIONS

Line 8673: FROM fnd_form_functions

8669: h_count NUMBER;
8670:
8671: CURSOR c_function_id IS
8672: SELECT function_id
8673: FROM fnd_form_functions
8674: WHERE function_name = p_function_name;
8675:
8676: h_rowid VARCHAR2(2000);
8677: h_function_id NUMBER;

Line 8709: ' FROM fnd_form_functions_vl@'||g_db_link||

8705: ' web_secured, web_icon, object_id, region_application_id, region_code,'||
8706: ' application_id, form_id, parameters, type, user_function_name,'||
8707: ' description, maintenance_mode_support, context_dependence, jrad_ref_path,'||
8708: ' created_by'||
8709: ' FROM fnd_form_functions_vl@'||g_db_link||
8710: ' WHERE function_name = :1';
8711: OPEN h_cursor FOR h_sql USING p_function_name;
8712: FETCH h_cursor INTO h_web_host_name, h_web_agent_name, h_web_html_call, h_web_encrypt_parameters,
8713: h_web_secured, h_web_icon, h_object_id, h_region_application_id, h_region_code,

Line 8738: FND_FORM_FUNCTIONS_PKG.DELETE_ROW(X_FUNCTION_ID => h_function_id);

8734: OPEN c_function_id;
8735: FETCH c_function_id INTO h_function_id;
8736: IF c_function_id%FOUND THEN
8737: -- Delete the form function from the target
8738: FND_FORM_FUNCTIONS_PKG.DELETE_ROW(X_FUNCTION_ID => h_function_id);
8739: END IF;
8740: CLOSE c_function_id;
8741:
8742: -- Create the form function in the target

Line 8743: SELECT fnd_form_functions_s.nextval INTO h_function_id FROM DUAL;

8739: END IF;
8740: CLOSE c_function_id;
8741:
8742: -- Create the form function in the target
8743: SELECT fnd_form_functions_s.nextval INTO h_function_id FROM DUAL;
8744:
8745: FND_FORM_FUNCTIONS_PKG.INSERT_ROW (
8746: X_ROWID => h_rowid,
8747: X_FUNCTION_ID => h_function_id,

Line 8745: FND_FORM_FUNCTIONS_PKG.INSERT_ROW (

8741:
8742: -- Create the form function in the target
8743: SELECT fnd_form_functions_s.nextval INTO h_function_id FROM DUAL;
8744:
8745: FND_FORM_FUNCTIONS_PKG.INSERT_ROW (
8746: X_ROWID => h_rowid,
8747: X_FUNCTION_ID => h_function_id,
8748: X_WEB_HOST_NAME => h_web_host_name,
8749: X_WEB_AGENT_NAME => h_web_agent_name,

Line 9575: l_New_Function_Id fnd_form_functions.function_id%TYPE;

9571: l_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;
9572: l_next_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;
9573: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
9574: h_sql VARCHAR2(3200);
9575: l_New_Function_Id fnd_form_functions.function_id%TYPE;
9576: l_Target_Value_char fnd_form_functions.function_name%TYPE;
9577: l_Target_Value fnd_form_functions.function_id%TYPE;
9578: l_Source_Value_char fnd_form_functions.function_name%TYPE;
9579: l_Source_Value fnd_form_functions.function_id%TYPE;

Line 9576: l_Target_Value_char fnd_form_functions.function_name%TYPE;

9572: l_next_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;
9573: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
9574: h_sql VARCHAR2(3200);
9575: l_New_Function_Id fnd_form_functions.function_id%TYPE;
9576: l_Target_Value_char fnd_form_functions.function_name%TYPE;
9577: l_Target_Value fnd_form_functions.function_id%TYPE;
9578: l_Source_Value_char fnd_form_functions.function_name%TYPE;
9579: l_Source_Value fnd_form_functions.function_id%TYPE;
9580: l_Old_Function_Id fnd_form_functions.function_id%TYPE;

Line 9577: l_Target_Value fnd_form_functions.function_id%TYPE;

9573: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
9574: h_sql VARCHAR2(3200);
9575: l_New_Function_Id fnd_form_functions.function_id%TYPE;
9576: l_Target_Value_char fnd_form_functions.function_name%TYPE;
9577: l_Target_Value fnd_form_functions.function_id%TYPE;
9578: l_Source_Value_char fnd_form_functions.function_name%TYPE;
9579: l_Source_Value fnd_form_functions.function_id%TYPE;
9580: l_Old_Function_Id fnd_form_functions.function_id%TYPE;
9581: CURSOR c_column IS

Line 9578: l_Source_Value_char fnd_form_functions.function_name%TYPE;

9574: h_sql VARCHAR2(3200);
9575: l_New_Function_Id fnd_form_functions.function_id%TYPE;
9576: l_Target_Value_char fnd_form_functions.function_name%TYPE;
9577: l_Target_Value fnd_form_functions.function_id%TYPE;
9578: l_Source_Value_char fnd_form_functions.function_name%TYPE;
9579: l_Source_Value fnd_form_functions.function_id%TYPE;
9580: l_Old_Function_Id fnd_form_functions.function_id%TYPE;
9581: CURSOR c_column IS
9582: SELECT column_name

Line 9579: l_Source_Value fnd_form_functions.function_id%TYPE;

9575: l_New_Function_Id fnd_form_functions.function_id%TYPE;
9576: l_Target_Value_char fnd_form_functions.function_name%TYPE;
9577: l_Target_Value fnd_form_functions.function_id%TYPE;
9578: l_Source_Value_char fnd_form_functions.function_name%TYPE;
9579: l_Source_Value fnd_form_functions.function_id%TYPE;
9580: l_Old_Function_Id fnd_form_functions.function_id%TYPE;
9581: CURSOR c_column IS
9582: SELECT column_name
9583: FROM all_tab_columns

Line 9580: l_Old_Function_Id fnd_form_functions.function_id%TYPE;

9576: l_Target_Value_char fnd_form_functions.function_name%TYPE;
9577: l_Target_Value fnd_form_functions.function_id%TYPE;
9578: l_Source_Value_char fnd_form_functions.function_name%TYPE;
9579: l_Source_Value fnd_form_functions.function_id%TYPE;
9580: l_Old_Function_Id fnd_form_functions.function_id%TYPE;
9581: CURSOR c_column IS
9582: SELECT column_name
9583: FROM all_tab_columns
9584: WHERE table_name = UPPER(l_table_name)

Line 9753: FND_FORM_FUNCTIONS_S.NEXTVAL

9749: END IF;
9750: END LOOP;
9751:
9752: SELECT
9753: FND_FORM_FUNCTIONS_S.NEXTVAL
9754: INTO
9755: l_New_Function_Id
9756: FROM dual;
9757:

Line 9836: UPDATE fnd_form_functions_tl tl

9832: short_name = p_Region_Code
9833: WHERE
9834: indicator = p_Trg_indicator;
9835:
9836: UPDATE fnd_form_functions_tl tl
9837: SET user_function_name = (SELECT name FROM bsc_kpis_tl k, bsc_kpis_b b
9838: WHERE b.indicator = k.indicator AND
9839: b.short_name = p_Region_Code AND k.language = tl.language)
9840: WHERE