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.JTF_AE_SQLUTIL_API dependencies on JTF_PROFILE_RULES_B

Line 248: p_rule IN JTF_Profile_Rules_B.rule%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,
252: p_SPID OUT NOCOPY /* file.sql.39 change */ NUMBER) IS

Line 249: p_userID IN JTF_Profile_Rules_B.created_by%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,
252: p_SPID OUT NOCOPY /* file.sql.39 change */ NUMBER) IS
253:

Line 325: p_appID IN JTF_PROFILE_RULES_B.last_updated_by%TYPE,

321: -- If new rule then add rule for instance specific attribute
322: -- Return the PROFILE_RULE_ID of the newly registered rule.
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,

Line 328: p_rule IN JTF_Profile_Rules_B.rule%TYPE,

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:
332: v_Result NUMBER;

Line 329: p_userID IN JTF_Profile_Rules_B.created_by%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:
332: v_Result NUMBER;
333: v_pMapID NUMBER;

Line 330: p_ruleID OUT NOCOPY /* file.sql.39 change */ JTF_Profile_Rules_B.profile_rules_id%TYPE) IS

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:
332: v_Result NUMBER;
333: v_pMapID NUMBER;
334: v_pSubProfID NUMBER;

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:

Line 375: select jtf_profile_rules_b_s1.NextVal

371:
372: CLOSE c_Rules;
373:
374: /* Step 4: Rule NOT Registered .. Add the new rule */
375: select jtf_profile_rules_b_s1.NextVal
376: into v_Result
377: from dual;
378:
379: JTF_AE_PROFRULES.INSERT_ROW (