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

38: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,
39: p_OID OUT NOCOPY /* file.sql.39 change */ NUMBER,
40: p_ATTR OUT NOCOPY /* file.sql.39 change */ JTF_ProfileProperties_B.attrname%TYPE);
41:
42: -- Insert a new ProfilePropertyDescriptor into JTF_Profile_Metadata_B/TL
43: -- Return the primary key for the newly inserted object.
44: PROCEDURE addAttribute (
45: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
46: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,

Line 46: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,

42: -- Insert a new ProfilePropertyDescriptor into JTF_Profile_Metadata_B/TL
43: -- Return the primary key for the newly inserted object.
44: PROCEDURE addAttribute (
45: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
46: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,
47: p_PropertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,
48: p_pID IN JTF_Profile_Metadata_B.profileproperties_ID%TYPE,
49: p_rID IN JTF_Profile_Metadata_B.profile_rules_ID%TYPE,
50: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,

Line 48: p_pID IN JTF_Profile_Metadata_B.profileproperties_ID%TYPE,

44: PROCEDURE addAttribute (
45: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
46: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,
47: p_PropertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,
48: p_pID IN JTF_Profile_Metadata_B.profileproperties_ID%TYPE,
49: p_rID IN JTF_Profile_Metadata_B.profile_rules_ID%TYPE,
50: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
51: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
52: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,

Line 49: p_rID IN JTF_Profile_Metadata_B.profile_rules_ID%TYPE,

45: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
46: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,
47: p_PropertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,
48: p_pID IN JTF_Profile_Metadata_B.profileproperties_ID%TYPE,
49: p_rID IN JTF_Profile_Metadata_B.profile_rules_ID%TYPE,
50: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
51: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
52: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,
53: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,

Line 50: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,

46: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,
47: p_PropertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,
48: p_pID IN JTF_Profile_Metadata_B.profileproperties_ID%TYPE,
49: p_rID IN JTF_Profile_Metadata_B.profile_rules_ID%TYPE,
50: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
51: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
52: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,
53: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,
54: p_userID IN JTF_Profile_Metadata_B.created_by%TYPE,

Line 51: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,

47: p_PropertyName IN JTF_ProfileProperties_TL.propertyName%TYPE,
48: p_pID IN JTF_Profile_Metadata_B.profileproperties_ID%TYPE,
49: p_rID IN JTF_Profile_Metadata_B.profile_rules_ID%TYPE,
50: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
51: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
52: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,
53: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,
54: p_userID IN JTF_Profile_Metadata_B.created_by%TYPE,
55: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 52: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,

48: p_pID IN JTF_Profile_Metadata_B.profileproperties_ID%TYPE,
49: p_rID IN JTF_Profile_Metadata_B.profile_rules_ID%TYPE,
50: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
51: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
52: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,
53: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,
54: p_userID IN JTF_Profile_Metadata_B.created_by%TYPE,
55: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,
56: p_OID OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 54: p_userID IN JTF_Profile_Metadata_B.created_by%TYPE,

50: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
51: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
52: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,
53: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,
54: p_userID IN JTF_Profile_Metadata_B.created_by%TYPE,
55: p_PK OUT NOCOPY /* file.sql.39 change */ NUMBER,
56: p_OID OUT NOCOPY /* file.sql.39 change */ NUMBER,
57: p_SPID OUT NOCOPY /* file.sql.39 change */ NUMBER);
58:

Line 64: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,

60: -- with the attribute is not registered yet, first register the rule.
61:
62: PROCEDURE addAttribute (
63: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
64: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,
65: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
66: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
67: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,
68: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,

Line 65: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,

61:
62: PROCEDURE addAttribute (
63: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
64: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,
65: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
66: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
67: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,
68: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,
69: p_extPropertyName IN JTF_PROFILEPROPERTIES_TL.propertyName%TYPE,

Line 66: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,

62: PROCEDURE addAttribute (
63: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
64: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,
65: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
66: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
67: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%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,

Line 67: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,

63: p_ProfileName IN JTF_PROFILE_MAPPINGS_TL.profileName%TYPE,
64: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,
65: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
66: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
67: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%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,

Line 80: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,

76: p_SPID OUT NOCOPY /* file.sql.39 change */ NUMBER);
77:
78: -- Modify an existing base or instance specific attribute
79: PROCEDURE modifyAttribute (
80: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,
81: p_Key IN JTF_Profile_Metadata_B.profile_metadata_id%TYPE,
82: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
83: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
84: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,

Line 81: p_Key IN JTF_Profile_Metadata_B.profile_metadata_id%TYPE,

77:
78: -- Modify an existing base or instance specific attribute
79: PROCEDURE modifyAttribute (
80: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,
81: p_Key IN JTF_Profile_Metadata_B.profile_metadata_id%TYPE,
82: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
83: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
84: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,
85: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,

Line 82: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,

78: -- Modify an existing base or instance specific attribute
79: PROCEDURE modifyAttribute (
80: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,
81: p_Key IN JTF_Profile_Metadata_B.profile_metadata_id%TYPE,
82: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
83: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
84: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,
85: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,
86: p_version IN JTF_Profile_Metadata_B.object_version_number%TYPE,

Line 83: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,

79: PROCEDURE modifyAttribute (
80: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,
81: p_Key IN JTF_Profile_Metadata_B.profile_metadata_id%TYPE,
82: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
83: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
84: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,
85: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,
86: p_version IN JTF_Profile_Metadata_B.object_version_number%TYPE,
87: p_userID IN JTF_Profile_Metadata_B.created_by%TYPE,

Line 84: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,

80: p_appID IN JTF_Profile_Metadata_B.last_updated_by%TYPE,
81: p_Key IN JTF_Profile_Metadata_B.profile_metadata_id%TYPE,
82: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
83: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
84: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,
85: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,
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);

Line 86: p_version IN JTF_Profile_Metadata_B.object_version_number%TYPE,

82: p_disabledCode IN JTF_Profile_Metadata_B.disabled_flag_code%TYPE,
83: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
84: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,
85: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,
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

Line 87: p_userID IN JTF_Profile_Metadata_B.created_by%TYPE,

83: p_mandatoryCode IN JTF_Profile_Metadata_B.mandatory_flag_code%TYPE,
84: p_javaTypeCode IN JTF_Profile_Metadata_B.java_datatype_code%TYPE,
85: p_default IN JTF_Profile_Metadata_TL.default_value%TYPE,
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.