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 72: p_rule IN JTF_Profile_Rules_B.rule%TYPE,

68: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,
69: p_extPropertyName IN JTF_PROFILEPROPERTIES_TL.propertyName%TYPE,
70: p_basePropertyName IN JTF_PROFILEPROPERTIES_TL.propertyName%TYPE,
71: p_basePropertyVal IN JTF_PROFILE_RULES_TL.base_property_value%TYPE,
72: p_rule IN JTF_Profile_Rules_B.rule%TYPE,
73: p_userID IN JTF_Profile_Rules_B.created_by%TYPE,
74: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,
75: p_OID OUT NOCOPY /* file.sql.39 change */ NUMBER,
76: p_SPID OUT NOCOPY /* file.sql.39 change */ NUMBER);

Line 73: p_userID IN JTF_Profile_Rules_B.created_by%TYPE,

69: p_extPropertyName IN JTF_PROFILEPROPERTIES_TL.propertyName%TYPE,
70: p_basePropertyName IN JTF_PROFILEPROPERTIES_TL.propertyName%TYPE,
71: p_basePropertyVal IN JTF_PROFILE_RULES_TL.base_property_value%TYPE,
72: p_rule IN JTF_Profile_Rules_B.rule%TYPE,
73: p_userID IN JTF_Profile_Rules_B.created_by%TYPE,
74: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,
75: p_OID OUT NOCOPY /* file.sql.39 change */ NUMBER,
76: p_SPID OUT NOCOPY /* file.sql.39 change */ NUMBER);
77:

Line 90: -- Add a new rule for instance specific attributes to JTF_PROFILE_RULES_B/TL

86: p_version IN JTF_Profile_Metadata_B.object_version_number%TYPE,
87: p_userID IN JTF_Profile_Metadata_B.created_by%TYPE,
88: p_Count OUT NOCOPY /* file.sql.39 change */ NUMBER);
89:
90: -- Add a new rule for instance specific attributes to JTF_PROFILE_RULES_B/TL
91: -- Return the PROFILE_RULE_ID generated.
92: PROCEDURE addRule(
93: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
94: p_appID IN JTF_PROFILE_RULES_B.last_updated_by%TYPE,

Line 94: p_appID IN JTF_PROFILE_RULES_B.last_updated_by%TYPE,

90: -- Add a new rule for instance specific attributes to JTF_PROFILE_RULES_B/TL
91: -- Return the PROFILE_RULE_ID generated.
92: PROCEDURE addRule(
93: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
94: p_appID IN JTF_PROFILE_RULES_B.last_updated_by%TYPE,
95: p_propertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,
96: p_baseValue IN JTF_PROFILE_RULES_TL.base_property_value%TYPE,
97: p_rule IN JTF_Profile_Rules_B.rule%TYPE,
98: p_userID IN JTF_Profile_Rules_B.created_by%TYPE,

Line 97: p_rule IN JTF_Profile_Rules_B.rule%TYPE,

93: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
94: p_appID IN JTF_PROFILE_RULES_B.last_updated_by%TYPE,
95: p_propertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,
96: p_baseValue IN JTF_PROFILE_RULES_TL.base_property_value%TYPE,
97: p_rule IN JTF_Profile_Rules_B.rule%TYPE,
98: p_userID IN JTF_Profile_Rules_B.created_by%TYPE,
99: p_ruleID OUT NOCOPY /* file.sql.39 change */ JTF_PROFILE_Rules_B.profile_rules_id%TYPE);
100:
101:

Line 98: p_userID IN JTF_Profile_Rules_B.created_by%TYPE,

94: p_appID IN JTF_PROFILE_RULES_B.last_updated_by%TYPE,
95: p_propertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,
96: p_baseValue IN JTF_PROFILE_RULES_TL.base_property_value%TYPE,
97: p_rule IN JTF_Profile_Rules_B.rule%TYPE,
98: p_userID IN JTF_Profile_Rules_B.created_by%TYPE,
99: p_ruleID OUT NOCOPY /* file.sql.39 change */ JTF_PROFILE_Rules_B.profile_rules_id%TYPE);
100:
101:
102: -- HELPER FUNCTIONS

Line 99: p_ruleID OUT NOCOPY /* file.sql.39 change */ JTF_PROFILE_Rules_B.profile_rules_id%TYPE);

95: p_propertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,
96: p_baseValue IN JTF_PROFILE_RULES_TL.base_property_value%TYPE,
97: p_rule IN JTF_Profile_Rules_B.rule%TYPE,
98: p_userID IN JTF_Profile_Rules_B.created_by%TYPE,
99: p_ruleID OUT NOCOPY /* file.sql.39 change */ JTF_PROFILE_Rules_B.profile_rules_id%TYPE);
100:
101:
102: -- HELPER FUNCTIONS
103: FUNCTION getProfileID(