DBA Data[Home] [Help]

APPS.JTF_AE_SQLUTIL_API dependencies on JTF_PROFILE_METADATA_TL

Line 183: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,

179: p_rID IN JTF_Profile_Metadata_B.profile_rules_ID%TYPE,
180: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
181: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
182: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,
183: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,
184: p_userID IN JTF_Profile_Metadata_B.created_by%TYPE,
185: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,
186: p_OID OUT NOCOPY /* file.sql.39 change */ NUMBER,
187: p_SPID OUT NOCOPY /* file.sql.39 change */ NUMBER) IS

Line 244: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,

240: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,
241: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
242: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
243: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,
244: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,
245: p_extPropertyName IN JTF_PROFILEPROPERTIES_TL.propertyName%TYPE,
246: p_basePropertyName IN JTF_PROFILEPROPERTIES_TL.propertyName%TYPE,
247: p_basePropertyVal IN JTF_PROFILE_RULES_TL.base_property_value%TYPE,
248: p_rule IN JTF_Profile_Rules_B.rule%TYPE,

Line 286: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,

282: p_Key IN JTF_Profile_Metadata_B.profile_metadata_id%TYPE,
283: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
284: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
285: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,
286: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,
287: p_version IN JTF_Profile_Metadata_B.object_version_number%TYPE,
288: p_userID IN JTF_Profile_Metadata_B.created_by%TYPE,
289: p_Count OUT NOCOPY /* file.sql.39 change */ NUMBER) IS
290:

Line 312: UPDATE JTF_PROFILE_METADATA_TL

308: return;
309: end if;
310:
311: /* Update successful, so modify _TL table */
312: UPDATE JTF_PROFILE_METADATA_TL
313: SET default_value = p_default,
314: last_update_date = SYSDATE,
315: last_updated_by = p_userID
316: WHERE profile_metadata_id = p_Key;