DBA Data[Home] [Help]

APPS.PAY_MAG_UTILS dependencies on FF_FUNCTIONS

Line 1115: -- This procedure checks to see if udf is already stored in ff_functions

1111: ----------------------------------------------------------------------------------------
1112: -- Name
1113: -- udf_Exists
1114: -- Purpose
1115: -- This procedure checks to see if udf is already stored in ff_functions
1116: -- Arguments
1117: -- p_udf_nam
1118: ----------------------------------------------------------------------------------------
1119: FUNCTION udf_Exists (p_udf_name in varchar2) RETURN NUMBER IS

Line 1127: from ff_functions

1123: begin
1124:
1125: select function_id
1126: into l_udf_id
1127: from ff_functions
1128: where upper(name) = upper(p_udf_name)
1129: and business_group_id is null
1130: and legislation_code = 'US';
1131:

Line 1144: -- removes udf from ff_function_parameters,ff_function_context_usages, ff_functions

1140: ----------------------------------------------------------------------------------------
1141: -- Name
1142: -- Delete_udf
1143: -- Purpose
1144: -- removes udf from ff_function_parameters,ff_function_context_usages, ff_functions
1145: -- Arguments
1146: -- p_udf_nam
1147: ----------------------------------------------------------------------------------------
1148:

Line 1162: delete from ff_functions

1158:
1159: delete from ff_function_context_usages
1160: where function_id = l_udf_id;
1161:
1162: delete from ff_functions
1163: where function_id = l_udf_id;
1164: end if;
1165:
1166: end Delete_udf;