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_MAPPINGS_TL

Line 6: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,

2: /* $Header: jtfaeapb.pls 120.2 2005/10/25 05:13:26 psanyal ship $ */
3:
4: -- Register a new profile for a base table
5: PROCEDURE registerProfile(
6: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
7: p_BaseTable IN JTF_PROFILE_MAPPINGS_TL.baseTable%TYPE,
8: p_AppID IN JTF_PROFILE_MAPPINGS_B.ownerID%TYPE,
9: p_userID IN JTF_PROFILE_MAPPINGS_B.created_by%TYPE) IS
10:

Line 7: p_BaseTable IN JTF_PROFILE_MAPPINGS_TL.baseTable%TYPE,

3:
4: -- Register a new profile for a base table
5: PROCEDURE registerProfile(
6: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
7: p_BaseTable IN JTF_PROFILE_MAPPINGS_TL.baseTable%TYPE,
8: p_AppID IN JTF_PROFILE_MAPPINGS_B.ownerID%TYPE,
9: p_userID IN JTF_PROFILE_MAPPINGS_B.created_by%TYPE) IS
10:
11: v_pKey NUMBER;

Line 38: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,

34: END registerProfile;
35:
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,

Line 80: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,

76:
77: -- Register Object_Version_Number
78:
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

Line 126: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,

122:
123: -- Insert a new Profile Owner object into JTF_ProfileProperties_B/TL
124: -- Return the primary key for the newly inserted object.
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,

Line 175: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,

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,
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,

Line 239: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,

235: -- Add an instance specific attribute. If the rule associated
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,

Line 324: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,

320:
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,

Line 402: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE)

398:
399: -- HELPER FUNCTIONS
400:
401: FUNCTION getProfileID(
402: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE)
403: RETURN NUMBER IS
404:
405: v_Result NUMBER;
406:

Line 411: FROM JTF_PROFILE_MAPPINGS_TL t

407: BEGIN
408:
409: SELECT profile_mappings_id
410: INTO v_Result
411: FROM JTF_PROFILE_MAPPINGS_TL t
412: WHERE t.profileName = p_profileName AND
413: t.language = userenv('LANG');
414:
415: RETURN v_Result;

Line 460: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,

456:
457: END getAttrName;
458:
459: PROCEDURE getAppProfileID(
460: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
461: p_appID IN JTF_SUBSCRIBED_PROFILES.application_id%TYPE,
462: p_PMAPID OUT NOCOPY /* file.sql.39 change */ NUMBER,
463: p_SUBID OUT NOCOPY /* file.sql.39 change */ NUMBER) IS
464:

Line 469: FROM JTF_SUBSCRIBED_PROFILES s, JTF_PROFILE_MAPPINGS_TL t

465: BEGIN
466:
467: SELECT s.profile_mappings_id,s.subscribed_profiles_id
468: INTO p_PMAPID, p_SUBID
469: FROM JTF_SUBSCRIBED_PROFILES s, JTF_PROFILE_MAPPINGS_TL t
470: WHERE s.application_id = p_appID
471: AND s.profile_mappings_id = t.profile_mappings_id
472: AND t.profileName = p_ProfileName AND t.language = userenv('LANG');
473: