APPS.JTF_AE_SQLUTIL_API dependencies on JTF_PROFILE_RULES_TL

Line 247: p_basePropertyVal IN JTF_PROFILE_RULES_TL.base_property_value%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,
249: p_userID IN JTF_Profile_Rules_B.created_by%TYPE,
250: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,
251: p_OID OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 327: p_baseValue IN JTF_PROFILE_RULES_TL.base_property_value%TYPE,

323: PROCEDURE addRule(
324: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
325: p_appID IN JTF_PROFILE_RULES_B.last_updated_by%TYPE,
326: p_propertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,
327: p_baseValue IN JTF_PROFILE_RULES_TL.base_property_value%TYPE,
328: p_rule IN JTF_Profile_Rules_B.rule%TYPE,
329: p_userID IN JTF_Profile_Rules_B.created_by%TYPE,
330: p_ruleID OUT NOCOPY /* file.sql.39 change */ JTF_Profile_Rules_B.profile_rules_id%TYPE) IS
331:

Line 339: FROM JTF_Profile_Rules_B b, JTF_Profile_Rules_TL t

335: v_pMetaID NUMBER;
336:
337: CURSOR c_Rules IS
338: SELECT b.profile_rules_id
339: FROM JTF_Profile_Rules_B b, JTF_Profile_Rules_TL t
340: WHERE b.profile_metadata_id = v_pMetaID AND
341: b.profile_rules_id = t.profile_rules_id and
342: t.base_property_value = p_baseValue and t.language = userenv('LANG');
343: