[Home] [Help]
1590: --- Function name
1591: ---
1592: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1593: set efpmi.function_name = ( select efv.internal_name
1594: from ego_functions_v efv
1595: where efv.function_id = efv.function_id
1596: )
1597: WHERE efpmi.function_name IS NULL
1598: AND efpmi.function_id IS NOT NULL
1608: --- Function id
1609: ---
1610: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1611: set efpmi.function_id = ( select efv.function_id
1612: from ego_functions_v efv
1613: where efv.internal_name = efpmi.function_name
1614: )
1615: WHERE efpmi.function_id IS NULL
1616: AND efpmi.function_name IS NOT NULL
2930:
2931:
2932: /******************************************
2933: ---- Function to check the function name
2934: ---- or ID provided against EGO_FUNCTIONS_V
2935: *****************************************/
2936:
2937: FUNCTION Check_Function ( p_func_id IN NUMBER DEFAULT NULL
2938: ,p_func_name IN VARCHAR2 DEFAULT NULL
2945:
2946: CURSOR cur_func
2947: IS
2948: SELECT function_id
2949: FROM ego_functions_v
2950: where ( function_id = nvl(p_func_id, function_id)
2951: AND
2952: internal_name = nvl(p_func_name, internal_name)
2953: ) ;