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_B

Line 39: p_appID IN JTF_ProfileProperties_B.last_updated_by%TYPE,

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,
43: p_userID IN JTF_ProfileProperties_B.created_by%TYPE ) IS

Line 41: p_attrName IN JTF_ProfileProperties_B.attrName%TYPE,

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:
45: v_FKey number;

Line 43: p_userID IN JTF_ProfileProperties_B.created_by%TYPE ) IS

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;
47:

Line 54: select jtf_profileproperties_b_s1.NextVal

50: /* Step 1: Get the profile_mappings_id for p_profileName */
51: v_FKey := getProfileID( p_ProfileName );
52:
53: /* Step 2: Get the nextVal for the primary key and object version */
54: select jtf_profileproperties_b_s1.NextVal
55: into v_Pkey
56: from dual;
57:
58: /* Insert into JTF_PROFILEPRPOPERTIES tables */

Line 81: p_appID IN JTF_ProfileProperties_B.last_updated_by%TYPE,

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

Line 82: p_attrName IN JTF_ProfileProperties_B.attrName%TYPE,

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
85:
86: v_FKey number;

Line 84: p_userID IN JTF_ProfileProperties_B.created_by%TYPE ) IS

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;
88: v_propertyName JTF_ProfileProperties_TL.propertyName%TYPE;

Line 98: select jtf_profileproperties_b_s1.NextVal

94:
95: v_propertyName := 'OBJECT_VERSION_NUMBER';
96:
97: /* Step 2: Get the nextVal for the primary key and object version */
98: select jtf_profileproperties_b_s1.NextVal
99: into v_Pkey
100: from dual;
101:
102: /* Insert into JTF_PROFILEPRPOPERTIES tables */

Line 123: -- Insert a new Profile Owner object into JTF_ProfileProperties_B/TL

119: End registerObjectVersion;
120:
121:
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,

Line 127: p_appID IN JTF_ProfileProperties_B.last_updated_by%TYPE,

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,
131: p_isBase IN NUMBER,

Line 128: p_OwnerID IN JTF_ProfileProperties_B.owner_application_id%TYPE,

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,
131: p_isBase IN NUMBER,
132: p_userID IN JTF_ProfileProperties_B.created_by%TYPE,

Line 132: p_userID IN JTF_ProfileProperties_B.created_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,
135: p_ATTR OUT NOCOPY /* file.sql.39 change */ JTF_ProfileProperties_B.attrname%TYPE) IS
136:

Line 135: p_ATTR OUT NOCOPY /* file.sql.39 change */ JTF_ProfileProperties_B.attrname%TYPE) IS

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,
135: p_ATTR OUT NOCOPY /* file.sql.39 change */ JTF_ProfileProperties_B.attrname%TYPE) IS
136:
137: v_FKey NUMBER;
138: BEGIN
139:

Line 147: select jtf_profileproperties_b_s1.NextVal

143: /* Step 2: Determine the attrName for new property */
144: p_ATTR := getAttrName( v_FKey, p_appID, p_isBase );
145:
146: /* Step 3: Get the nextVal for the primary key and object version */
147: select jtf_profileproperties_b_s1.NextVal
148: into p_PK
149: from dual;
150:
151: p_OID := 0;

Line 258: v_attr JTF_ProfileProperties_B.attrname%TYPE;

254: v_pMapID NUMBER;
255: v_ruleID NUMBER;
256: v_PK NUMBER;
257: v_OID NUMBER;
258: v_attr JTF_ProfileProperties_B.attrname%TYPE;
259:
260: BEGIN
261:
262: /* Check to see if the rule is registered */

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

Line 425: v_Result JTF_ProfileProperties_B.attrname%TYPE;

421: p_appID IN NUMBER,
422: p_isBase in NUMBER )
423: RETURN VARCHAR2 IS
424:
425: v_Result JTF_ProfileProperties_B.attrname%TYPE;
426: v_tmp1 JTF_ProfileProperties_B.attrname%TYPE;
427: v_tmp2 JTF_ProfileProperties_B.attrname%TYPE;
428: v_index NUMBER;
429:

Line 426: v_tmp1 JTF_ProfileProperties_B.attrname%TYPE;

422: p_isBase in NUMBER )
423: RETURN VARCHAR2 IS
424:
425: v_Result JTF_ProfileProperties_B.attrname%TYPE;
426: v_tmp1 JTF_ProfileProperties_B.attrname%TYPE;
427: v_tmp2 JTF_ProfileProperties_B.attrname%TYPE;
428: v_index NUMBER;
429:
430: BEGIN

Line 427: v_tmp2 JTF_ProfileProperties_B.attrname%TYPE;

423: RETURN VARCHAR2 IS
424:
425: v_Result JTF_ProfileProperties_B.attrname%TYPE;
426: v_tmp1 JTF_ProfileProperties_B.attrname%TYPE;
427: v_tmp2 JTF_ProfileProperties_B.attrname%TYPE;
428: v_index NUMBER;
429:
430: BEGIN
431:

Line 443: FROM JTF_ProfileProperties_B

439: END IF;
440:
441: SELECT MAX(TO_NUMBER(LTRIM(ATTRNAME,v_tmp1)))
442: INTO v_index
443: FROM JTF_ProfileProperties_B
444: WHERE profile_mappings_id = p_profile_mappings_id
445: AND attrname LIKE v_tmp2;
446:
447: if v_index >= 0 then