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_METADATA_B

Line 172: -- Insert a new ProfilePropertyDescriptor into JTF_Profile_Metadata_B/TL

168: X_LAST_UPDATE_LOGIN => 0);
169:
170: END addAttribute;
171:
172: -- Insert a new ProfilePropertyDescriptor into JTF_Profile_Metadata_B/TL
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,

Line 176: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,

172: -- Insert a new ProfilePropertyDescriptor into JTF_Profile_Metadata_B/TL
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,

Line 178: p_pID IN JTF_Profile_Metadata_B.profileproperties_ID%TYPE,

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,
182: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,

Line 179: p_rID IN JTF_Profile_Metadata_B.profile_rules_ID%TYPE,

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,
182: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,
183: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,

Line 180: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%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,
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,

Line 181: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%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,
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,

Line 182: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%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,
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,

Line 184: p_userID IN JTF_Profile_Metadata_B.created_by%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
188:

Line 208: select jtf_profile_metadata_b_s1.NextVal

204: v_pPID := p_PID;
205: end if;
206:
207: /* Step 3: Get the nextVal for the primary key */
208: select jtf_profile_metadata_b_s1.NextVal
209: into p_PK
210: from dual;
211:
212: p_OID := 0;

Line 240: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,

236: -- with the attribute is not registered yet, first register the rule.
237:
238: PROCEDURE addAttribute (
239: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%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,

Line 241: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,

237:
238: PROCEDURE addAttribute (
239: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%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,

Line 242: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,

238: PROCEDURE addAttribute (
239: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%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,

Line 243: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,

239: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%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,

Line 281: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,

277: END addAttribute;
278:
279: -- Modify an existing base or instance specific attribute
280: PROCEDURE modifyAttribute (
281: p_appID IN JTF_Profile_Metadata_B.last_updated_by%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,

Line 282: p_Key IN JTF_Profile_Metadata_B.profile_metadata_id%TYPE,

278:
279: -- Modify an existing base or instance specific attribute
280: PROCEDURE modifyAttribute (
281: p_appID IN JTF_Profile_Metadata_B.last_updated_by%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,

Line 283: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,

279: -- Modify an existing base or instance specific attribute
280: PROCEDURE modifyAttribute (
281: p_appID IN JTF_Profile_Metadata_B.last_updated_by%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,

Line 284: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,

280: PROCEDURE modifyAttribute (
281: p_appID IN JTF_Profile_Metadata_B.last_updated_by%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,

Line 285: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,

281: p_appID IN JTF_Profile_Metadata_B.last_updated_by%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

Line 287: p_version IN JTF_Profile_Metadata_B.object_version_number%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:
291: BEGIN

Line 288: p_userID IN JTF_Profile_Metadata_B.created_by%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:
291: BEGIN
292:

Line 295: UPDATE JTF_PROFILE_METADATA_B

291: BEGIN
292:
293: /* Modify the _B table first */
294:
295: UPDATE JTF_PROFILE_METADATA_B
296: SET disabled_flag_code = p_disabledCode,
297: mandatory_flag_code = p_mandatoryCode,
298: java_datatype_code = p_javaTypeCode,
299: last_update_date = SYSDATE,

Line 352: FROM JTF_Profile_Metadata_B a, JTF_ProfileProperties_B b,

348:
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