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_PROFILEPROPERTIES_TL

Line 40: p_propertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,

36: -- Register primary key
37: PROCEDURE registerPrimaryKey(
38: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
39: p_appID IN JTF_ProfileProperties_B.last_updated_by%TYPE,
40: p_propertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,
41: p_attrName IN JTF_ProfileProperties_B.attrName%TYPE,
42: p_propDesc IN JTF_ProfileProperties_TL.prop_description%TYPE,
43: p_userID IN JTF_ProfileProperties_B.created_by%TYPE ) IS
44:

Line 42: p_propDesc IN JTF_ProfileProperties_TL.prop_description%TYPE,

38: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
39: p_appID IN JTF_ProfileProperties_B.last_updated_by%TYPE,
40: p_propertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,
41: p_attrName IN JTF_ProfileProperties_B.attrName%TYPE,
42: p_propDesc IN JTF_ProfileProperties_TL.prop_description%TYPE,
43: p_userID IN JTF_ProfileProperties_B.created_by%TYPE ) IS
44:
45: v_FKey number;
46: v_PKey number;

Line 83: p_propDesc IN JTF_ProfileProperties_TL.prop_description%TYPE,

79: PROCEDURE registerObjectVersion(
80: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
81: p_appID IN JTF_ProfileProperties_B.last_updated_by%TYPE,
82: p_attrName IN JTF_ProfileProperties_B.attrName%TYPE,
83: p_propDesc IN JTF_ProfileProperties_TL.prop_description%TYPE,
84: p_userID IN JTF_ProfileProperties_B.created_by%TYPE ) IS
85:
86: v_FKey number;
87: v_PKey number;

Line 88: v_propertyName JTF_ProfileProperties_TL.propertyName%TYPE;

84: p_userID IN JTF_ProfileProperties_B.created_by%TYPE ) IS
85:
86: v_FKey number;
87: v_PKey number;
88: v_propertyName JTF_ProfileProperties_TL.propertyName%TYPE;
89:
90: Begin
91:
92: /* Step 1: Get the profile_mappings_id for p_profileName */

Line 129: p_propertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,

125: PROCEDURE addAttribute (
126: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
127: p_appID IN JTF_ProfileProperties_B.last_updated_by%TYPE,
128: p_OwnerID IN JTF_ProfileProperties_B.owner_application_id%TYPE,
129: p_propertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,
130: p_propDesc IN JTF_ProfileProperties_TL.prop_description%TYPE,
131: p_isBase IN NUMBER,
132: p_userID IN JTF_ProfileProperties_B.created_by%TYPE,
133: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 130: p_propDesc IN JTF_ProfileProperties_TL.prop_description%TYPE,

126: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
127: p_appID IN JTF_ProfileProperties_B.last_updated_by%TYPE,
128: p_OwnerID IN JTF_ProfileProperties_B.owner_application_id%TYPE,
129: p_propertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,
130: p_propDesc IN JTF_ProfileProperties_TL.prop_description%TYPE,
131: p_isBase IN NUMBER,
132: p_userID IN JTF_ProfileProperties_B.created_by%TYPE,
133: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,
134: p_OID OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 177: p_PropertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,

173: -- Return the primary key for the newly inserted object.
174: PROCEDURE addAttribute (
175: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
176: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,
177: p_PropertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,
178: p_pID IN JTF_Profile_Metadata_B.profileproperties_ID%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,

Line 201: from jtf_profileproperties_tl t

197: /* Step 2: If p_pID is null or -1 then determine it */
198: if p_PID = NULL OR p_PID = -1 then
199: select profileproperties_id
200: into v_pPID
201: from jtf_profileproperties_tl t
202: where t.propertyname = p_PropertyName AND t.language = userenv('LANG');
203: else
204: v_pPID := p_PID;
205: end if;

Line 245: p_extPropertyName IN JTF_PROFILEPROPERTIES_TL.propertyName%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,
249: p_userID IN JTF_Profile_Rules_B.created_by%TYPE,

Line 246: p_basePropertyName IN JTF_PROFILEPROPERTIES_TL.propertyName%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,
249: p_userID IN JTF_Profile_Rules_B.created_by%TYPE,
250: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 326: p_propertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,

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,
330: p_ruleID OUT NOCOPY /* file.sql.39 change */ JTF_Profile_Rules_B.profile_rules_id%TYPE) IS

Line 353: JTF_ProfileProperties_TL t

349: /* Step 2: Determine the profile_metadata_id */
350: SELECT a.profile_metadata_id
351: INTO v_pMetaID
352: FROM JTF_Profile_Metadata_B a, JTF_ProfileProperties_B b,
353: JTF_ProfileProperties_TL t
354: WHERE a.subscribed_profiles_id = v_pSubProfID
355: AND a.profileproperties_id = b.profileproperties_id
356: AND b.profile_mappings_id = v_pMapID
357: AND b.profileproperties_id = t.profileproperties_id