DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_VALUES_PVT dependencies on JTF_RS_RESOURCE_VALUES

Line 1: PACKAGE BODY jtf_rs_resource_values_pvt AS

1: PACKAGE BODY jtf_rs_resource_values_pvt AS
2: /* $Header: jtfrsvcb.pls 120.2 2005/08/29 20:08:22 baianand ship $ */
3:
4: /*****************************************************************************************
5: This is a private API that caller will invoke.

Line 20: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_RESOURCE_VALUES_PVT';

16: to do actual inserts, updates, deletes and queries from the tables.
17: ******************************************************************************************/
18:
19: /* Package variables. */
20: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_RESOURCE_VALUES_PVT';
21:
22: /* Procedure to Create Resource Values based on the
23: input values provided by the calling routines */
24:

Line 61: L_ATTRIBUTE1 JTF_RS_RESOURCE_VALUES.ATTRIBUTE1%TYPE := p_attribute1;

57: l_resource_id NUMBER := P_RESOURCE_ID;
58: l_resource_param_id NUMBER := P_RESOURCE_PARAM_ID;
59: l_value VARCHAR2(255) := P_VALUE;
60: l_value_type VARCHAR2(30) := P_VALUE_TYPE;
61: L_ATTRIBUTE1 JTF_RS_RESOURCE_VALUES.ATTRIBUTE1%TYPE := p_attribute1;
62: L_ATTRIBUTE2 JTF_RS_RESOURCE_VALUES.ATTRIBUTE2%TYPE := p_attribute2;
63: L_ATTRIBUTE3 JTF_RS_RESOURCE_VALUES.ATTRIBUTE3%TYPE := p_attribute3;
64: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;
65: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;

Line 62: L_ATTRIBUTE2 JTF_RS_RESOURCE_VALUES.ATTRIBUTE2%TYPE := p_attribute2;

58: l_resource_param_id NUMBER := P_RESOURCE_PARAM_ID;
59: l_value VARCHAR2(255) := P_VALUE;
60: l_value_type VARCHAR2(30) := P_VALUE_TYPE;
61: L_ATTRIBUTE1 JTF_RS_RESOURCE_VALUES.ATTRIBUTE1%TYPE := p_attribute1;
62: L_ATTRIBUTE2 JTF_RS_RESOURCE_VALUES.ATTRIBUTE2%TYPE := p_attribute2;
63: L_ATTRIBUTE3 JTF_RS_RESOURCE_VALUES.ATTRIBUTE3%TYPE := p_attribute3;
64: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;
65: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;
66: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;

Line 63: L_ATTRIBUTE3 JTF_RS_RESOURCE_VALUES.ATTRIBUTE3%TYPE := p_attribute3;

59: l_value VARCHAR2(255) := P_VALUE;
60: l_value_type VARCHAR2(30) := P_VALUE_TYPE;
61: L_ATTRIBUTE1 JTF_RS_RESOURCE_VALUES.ATTRIBUTE1%TYPE := p_attribute1;
62: L_ATTRIBUTE2 JTF_RS_RESOURCE_VALUES.ATTRIBUTE2%TYPE := p_attribute2;
63: L_ATTRIBUTE3 JTF_RS_RESOURCE_VALUES.ATTRIBUTE3%TYPE := p_attribute3;
64: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;
65: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;
66: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;
67: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;

Line 64: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;

60: l_value_type VARCHAR2(30) := P_VALUE_TYPE;
61: L_ATTRIBUTE1 JTF_RS_RESOURCE_VALUES.ATTRIBUTE1%TYPE := p_attribute1;
62: L_ATTRIBUTE2 JTF_RS_RESOURCE_VALUES.ATTRIBUTE2%TYPE := p_attribute2;
63: L_ATTRIBUTE3 JTF_RS_RESOURCE_VALUES.ATTRIBUTE3%TYPE := p_attribute3;
64: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;
65: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;
66: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;
67: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;
68: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;

Line 65: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;

61: L_ATTRIBUTE1 JTF_RS_RESOURCE_VALUES.ATTRIBUTE1%TYPE := p_attribute1;
62: L_ATTRIBUTE2 JTF_RS_RESOURCE_VALUES.ATTRIBUTE2%TYPE := p_attribute2;
63: L_ATTRIBUTE3 JTF_RS_RESOURCE_VALUES.ATTRIBUTE3%TYPE := p_attribute3;
64: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;
65: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;
66: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;
67: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;
68: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;
69: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;

Line 66: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;

62: L_ATTRIBUTE2 JTF_RS_RESOURCE_VALUES.ATTRIBUTE2%TYPE := p_attribute2;
63: L_ATTRIBUTE3 JTF_RS_RESOURCE_VALUES.ATTRIBUTE3%TYPE := p_attribute3;
64: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;
65: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;
66: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;
67: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;
68: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;
69: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;
70: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;

Line 67: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;

63: L_ATTRIBUTE3 JTF_RS_RESOURCE_VALUES.ATTRIBUTE3%TYPE := p_attribute3;
64: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;
65: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;
66: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;
67: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;
68: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;
69: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;
70: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;
71: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;

Line 68: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;

64: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;
65: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;
66: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;
67: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;
68: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;
69: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;
70: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;
71: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;
72: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;

Line 69: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;

65: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;
66: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;
67: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;
68: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;
69: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;
70: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;
71: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;
72: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;
73: L_ATTRIBUTE13 JTF_RS_RESOURCE_VALUES.ATTRIBUTE13%TYPE := p_attribute13;

Line 70: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;

66: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;
67: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;
68: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;
69: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;
70: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;
71: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;
72: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;
73: L_ATTRIBUTE13 JTF_RS_RESOURCE_VALUES.ATTRIBUTE13%TYPE := p_attribute13;
74: L_ATTRIBUTE14 JTF_RS_RESOURCE_VALUES.ATTRIBUTE14%TYPE := p_attribute14;

Line 71: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;

67: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;
68: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;
69: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;
70: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;
71: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;
72: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;
73: L_ATTRIBUTE13 JTF_RS_RESOURCE_VALUES.ATTRIBUTE13%TYPE := p_attribute13;
74: L_ATTRIBUTE14 JTF_RS_RESOURCE_VALUES.ATTRIBUTE14%TYPE := p_attribute14;
75: L_ATTRIBUTE15 JTF_RS_RESOURCE_VALUES.ATTRIBUTE15%TYPE := p_attribute15;

Line 72: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;

68: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;
69: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;
70: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;
71: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;
72: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;
73: L_ATTRIBUTE13 JTF_RS_RESOURCE_VALUES.ATTRIBUTE13%TYPE := p_attribute13;
74: L_ATTRIBUTE14 JTF_RS_RESOURCE_VALUES.ATTRIBUTE14%TYPE := p_attribute14;
75: L_ATTRIBUTE15 JTF_RS_RESOURCE_VALUES.ATTRIBUTE15%TYPE := p_attribute15;
76: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_VALUES.ATTRIBUTE_CATEGORY%TYPE := p_attribute_category;

Line 73: L_ATTRIBUTE13 JTF_RS_RESOURCE_VALUES.ATTRIBUTE13%TYPE := p_attribute13;

69: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;
70: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;
71: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;
72: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;
73: L_ATTRIBUTE13 JTF_RS_RESOURCE_VALUES.ATTRIBUTE13%TYPE := p_attribute13;
74: L_ATTRIBUTE14 JTF_RS_RESOURCE_VALUES.ATTRIBUTE14%TYPE := p_attribute14;
75: L_ATTRIBUTE15 JTF_RS_RESOURCE_VALUES.ATTRIBUTE15%TYPE := p_attribute15;
76: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_VALUES.ATTRIBUTE_CATEGORY%TYPE := p_attribute_category;
77:

Line 74: L_ATTRIBUTE14 JTF_RS_RESOURCE_VALUES.ATTRIBUTE14%TYPE := p_attribute14;

70: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;
71: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;
72: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;
73: L_ATTRIBUTE13 JTF_RS_RESOURCE_VALUES.ATTRIBUTE13%TYPE := p_attribute13;
74: L_ATTRIBUTE14 JTF_RS_RESOURCE_VALUES.ATTRIBUTE14%TYPE := p_attribute14;
75: L_ATTRIBUTE15 JTF_RS_RESOURCE_VALUES.ATTRIBUTE15%TYPE := p_attribute15;
76: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_VALUES.ATTRIBUTE_CATEGORY%TYPE := p_attribute_category;
77:
78: -- added to handle NOCOPY of JTF_RESOURCE_UTL package

Line 75: L_ATTRIBUTE15 JTF_RS_RESOURCE_VALUES.ATTRIBUTE15%TYPE := p_attribute15;

71: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;
72: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;
73: L_ATTRIBUTE13 JTF_RS_RESOURCE_VALUES.ATTRIBUTE13%TYPE := p_attribute13;
74: L_ATTRIBUTE14 JTF_RS_RESOURCE_VALUES.ATTRIBUTE14%TYPE := p_attribute14;
75: L_ATTRIBUTE15 JTF_RS_RESOURCE_VALUES.ATTRIBUTE15%TYPE := p_attribute15;
76: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_VALUES.ATTRIBUTE_CATEGORY%TYPE := p_attribute_category;
77:
78: -- added to handle NOCOPY of JTF_RESOURCE_UTL package
79: l_resource_id_out NUMBER;

Line 76: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_VALUES.ATTRIBUTE_CATEGORY%TYPE := p_attribute_category;

72: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;
73: L_ATTRIBUTE13 JTF_RS_RESOURCE_VALUES.ATTRIBUTE13%TYPE := p_attribute13;
74: L_ATTRIBUTE14 JTF_RS_RESOURCE_VALUES.ATTRIBUTE14%TYPE := p_attribute14;
75: L_ATTRIBUTE15 JTF_RS_RESOURCE_VALUES.ATTRIBUTE15%TYPE := p_attribute15;
76: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_VALUES.ATTRIBUTE_CATEGORY%TYPE := p_attribute_category;
77:
78: -- added to handle NOCOPY of JTF_RESOURCE_UTL package
79: l_resource_id_out NUMBER;
80:

Line 86: CURSOR c_jtf_rs_resource_values( l_rowid IN ROWID ) IS

82: l_resource_param_value_id NUMBER;
83: l_bind_data_id NUMBER;
84: l_check_char VARCHAR2(1);
85:
86: CURSOR c_jtf_rs_resource_values( l_rowid IN ROWID ) IS
87: SELECT 'Y'
88: FROM jtf_rs_resource_values
89: WHERE ROWID = l_rowid;
90:

Line 88: FROM jtf_rs_resource_values

84: l_check_char VARCHAR2(1);
85:
86: CURSOR c_jtf_rs_resource_values( l_rowid IN ROWID ) IS
87: SELECT 'Y'
88: FROM jtf_rs_resource_values
89: WHERE ROWID = l_rowid;
90:
91: CURSOR c_rs_values_dup IS
92: SELECT 'Y'

Line 93: FROM jtf_rs_resource_values

89: WHERE ROWID = l_rowid;
90:
91: CURSOR c_rs_values_dup IS
92: SELECT 'Y'
93: FROM jtf_rs_resource_values
94: WHERE resource_param_id = l_resource_param_id
95: AND resource_id = l_resource_id
96: AND value_type = l_value_type;
97:

Line 104: l_value1 jtf_rs_resource_values.value%TYPE;

100: from jtf_rs_resource_params
101: where resource_param_id = c_resource_param_id;
102:
103: l_type jtf_rs_resource_params.type%TYPE;
104: l_value1 jtf_rs_resource_values.value%TYPE;
105:
106: BEGIN
107:
108: SAVEPOINT create_rs_resource_values_pvt;

Line 122: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_id :=l_resource_id;

118: END IF;
119:
120: --Initializing the Internal User Hook Record parameter values
121:
122: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_id :=l_resource_id;
123: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_param_id := l_resource_param_id;
124: jtf_rs_resource_values_pub.p_rs_value_user_hook.value_type := l_value_type;
125: jtf_rs_resource_values_pub.p_rs_value_user_hook.value := l_value;
126:

Line 123: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_param_id := l_resource_param_id;

119:
120: --Initializing the Internal User Hook Record parameter values
121:
122: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_id :=l_resource_id;
123: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_param_id := l_resource_param_id;
124: jtf_rs_resource_values_pub.p_rs_value_user_hook.value_type := l_value_type;
125: jtf_rs_resource_values_pub.p_rs_value_user_hook.value := l_value;
126:
127: --Make the pre processing call to the user hooks

Line 124: jtf_rs_resource_values_pub.p_rs_value_user_hook.value_type := l_value_type;

120: --Initializing the Internal User Hook Record parameter values
121:
122: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_id :=l_resource_id;
123: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_param_id := l_resource_param_id;
124: jtf_rs_resource_values_pub.p_rs_value_user_hook.value_type := l_value_type;
125: jtf_rs_resource_values_pub.p_rs_value_user_hook.value := l_value;
126:
127: --Make the pre processing call to the user hooks
128:

Line 125: jtf_rs_resource_values_pub.p_rs_value_user_hook.value := l_value;

121:
122: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_id :=l_resource_id;
123: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_param_id := l_resource_param_id;
124: jtf_rs_resource_values_pub.p_rs_value_user_hook.value_type := l_value_type;
125: jtf_rs_resource_values_pub.p_rs_value_user_hook.value := l_value;
126:
127: --Make the pre processing call to the user hooks
128:
129: --Pre Call to the Customer Type User Hook

Line 132: 'JTF_RS_RESOURCE_VALUES_PVT',

128:
129: --Pre Call to the Customer Type User Hook
130:
131: IF jtf_usr_hks.ok_to_execute(
132: 'JTF_RS_RESOURCE_VALUES_PVT',
133: 'CREATE_RS_RESOURCE_VALUES',
134: 'B',
135: 'C')
136: THEN

Line 137: jtf_rs_resource_values_cuhk.create_rs_resource_values_pre(

133: 'CREATE_RS_RESOURCE_VALUES',
134: 'B',
135: 'C')
136: THEN
137: jtf_rs_resource_values_cuhk.create_rs_resource_values_pre(
138: P_RESOURCE_ID => l_resource_id,
139: P_RESOURCE_PARAM_ID => l_resource_param_id,
140: P_VALUE => l_value,
141: P_VALUE_TYPE => l_value_type,

Line 158: 'JTF_RS_RESOURCE_VALUES_PVT',

154:
155: --Pre Call to the Vertical Type User Hook
156:
157: IF jtf_usr_hks.ok_to_execute(
158: 'JTF_RS_RESOURCE_VALUES_PVT',
159: 'CREATE_RS_RESOURCE_VALUES',
160: 'B',
161: 'V')
162: THEN

Line 163: jtf_rs_resource_values_vuhk.create_rs_resource_values_pre(

159: 'CREATE_RS_RESOURCE_VALUES',
160: 'B',
161: 'V')
162: THEN
163: jtf_rs_resource_values_vuhk.create_rs_resource_values_pre(
164: P_RESOURCE_ID => l_resource_id,
165: P_RESOURCE_PARAM_ID => l_resource_param_id,
166: P_VALUE => l_value,
167: P_VALUE_TYPE => l_value_type,

Line 182: jtf_rs_resource_values_iuhk.create_rs_resource_values_pre(

178: END IF;
179: END IF;
180:
181: --Pre Call to the Internal Type User Hook
182: jtf_rs_resource_values_iuhk.create_rs_resource_values_pre(
183: X_RETURN_STATUS => x_return_status
184: );
185:
186: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 277: jtf_rs_resource_values_pkg.insert_row(

273: INTO l_resource_param_value_id
274: FROM dual;
275:
276: --Call the Table Handler to Insert Values
277: jtf_rs_resource_values_pkg.insert_row(
278: X_ROWID => l_rowid,
279: X_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id,
280: X_RESOURCE_ID => l_resource_id,
281: X_RESOURCE_PARAM_ID => l_resource_param_id,

Line 317: fnd_vault.put(l_resource_param_value_id, 'JTF_RS_RESOURCE_VALUES', p_value);

313:
314: -- This is for bug fix # 3870910
315: -- Password will be stored using fnd_vault API
316: if (l_resource_param_value_id is NOT NULL and p_value is NOT NULL and l_type = 'PASSWORD') then
317: fnd_vault.put(l_resource_param_value_id, 'JTF_RS_RESOURCE_VALUES', p_value);
318: end if;
319:
320: --Make the post processing call to the user hooks
321:

Line 325: 'JTF_RS_RESOURCE_VALUES_PVT',

321:
322: --Post Call to the Customer Type User Hook
323:
324: IF jtf_usr_hks.ok_to_execute(
325: 'JTF_RS_RESOURCE_VALUES_PVT',
326: 'CREATE_RS_RESOURCE_VALUES',
327: 'A',
328: 'C')
329: THEN

Line 330: jtf_rs_resource_values_cuhk.create_rs_resource_values_post(

326: 'CREATE_RS_RESOURCE_VALUES',
327: 'A',
328: 'C')
329: THEN
330: jtf_rs_resource_values_cuhk.create_rs_resource_values_post(
331: P_RESOURCE_ID => l_resource_id,
332: P_RESOURCE_PARAM_ID => l_resource_param_id,
333: P_VALUE => l_value,
334: P_VALUE_TYPE => l_value_type,

Line 351: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_param_value_id :=l_resource_param_value_id;

347: END IF;
348:
349: --Initializing the Internal User Hook Record parameter value
350:
351: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_param_value_id :=l_resource_param_value_id;
352:
353: --Post Call to the Vertical Type User Hook
354:
355: IF jtf_usr_hks.ok_to_execute(

Line 356: 'JTF_RS_RESOURCE_VALUES_PVT',

352:
353: --Post Call to the Vertical Type User Hook
354:
355: IF jtf_usr_hks.ok_to_execute(
356: 'JTF_RS_RESOURCE_VALUES_PVT',
357: 'CREATE_RS_RESOURCE_VALUES',
358: 'A',
359: 'V')
360: THEN

Line 361: jtf_rs_resource_values_vuhk.create_rs_resource_values_post(

357: 'CREATE_RS_RESOURCE_VALUES',
358: 'A',
359: 'V')
360: THEN
361: jtf_rs_resource_values_vuhk.create_rs_resource_values_post(
362: P_RESOURCE_ID => l_resource_id,
363: P_RESOURCE_PARAM_ID => l_resource_param_id,
364: P_VALUE => l_value,
365: P_VALUE_TYPE => l_value_type,

Line 382: jtf_rs_resource_values_iuhk.create_rs_resource_values_post(

378: END IF;
379:
380: --Post Call to the Internal Type User Hook
381:
382: jtf_rs_resource_values_iuhk.create_rs_resource_values_post(
383: X_RETURN_STATUS => x_return_status
384: );
385: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
386: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 395: 'JTF_RS_RESOURCE_VALUES_PVT',

391:
392: /* Standard call for Message Generation */
393:
394: IF jtf_usr_hks.ok_to_execute(
395: 'JTF_RS_RESOURCE_VALUES_PVT',
396: 'CREATE_RS_RESOURCE_VALUES',
397: 'M',
398: 'M')
399: THEN

Line 400: IF (jtf_rs_resource_values_cuhk.ok_to_generate_msg(

396: 'CREATE_RS_RESOURCE_VALUES',
397: 'M',
398: 'M')
399: THEN
400: IF (jtf_rs_resource_values_cuhk.ok_to_generate_msg(
401: p_resource_param_value_id => l_resource_param_value_id,
402: x_return_status => x_return_status) )
403: THEN
404:

Line 474: p_object_version_number IN OUT NOCOPY JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE,

470: P_ATTRIBUTE13 IN VARCHAR2,
471: P_ATTRIBUTE14 IN VARCHAR2,
472: P_ATTRIBUTE15 IN VARCHAR2,
473: P_ATTRIBUTE_CATEGORY IN VARCHAR2,
474: p_object_version_number IN OUT NOCOPY JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE,
475: X_Return_Status OUT NOCOPY VARCHAR2,
476: X_Msg_Count OUT NOCOPY NUMBER,
477: X_Msg_Data OUT NOCOPY VARCHAR2
478: )IS

Line 486: L_OBJECT_VERSION_NUMBER JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE := p_object_version_number;

482: L_RESOURCE_PARAM_ID NUMBER;
483: L_RESOURCE_ID NUMBER;
484: L_VALUE_TYPE VARCHAR2 (30);
485: L_VALUE VARCHAR2 (255) := p_value;
486: L_OBJECT_VERSION_NUMBER JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE := p_object_version_number;
487: L_ATTRIBUTE1 JTF_RS_RESOURCE_VALUES.ATTRIBUTE1%TYPE := p_attribute1;
488: L_ATTRIBUTE2 JTF_RS_RESOURCE_VALUES.ATTRIBUTE2%TYPE := p_attribute2;
489: L_ATTRIBUTE3 JTF_RS_RESOURCE_VALUES.ATTRIBUTE3%TYPE := p_attribute3;
490: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;

Line 487: L_ATTRIBUTE1 JTF_RS_RESOURCE_VALUES.ATTRIBUTE1%TYPE := p_attribute1;

483: L_RESOURCE_ID NUMBER;
484: L_VALUE_TYPE VARCHAR2 (30);
485: L_VALUE VARCHAR2 (255) := p_value;
486: L_OBJECT_VERSION_NUMBER JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE := p_object_version_number;
487: L_ATTRIBUTE1 JTF_RS_RESOURCE_VALUES.ATTRIBUTE1%TYPE := p_attribute1;
488: L_ATTRIBUTE2 JTF_RS_RESOURCE_VALUES.ATTRIBUTE2%TYPE := p_attribute2;
489: L_ATTRIBUTE3 JTF_RS_RESOURCE_VALUES.ATTRIBUTE3%TYPE := p_attribute3;
490: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;
491: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;

Line 488: L_ATTRIBUTE2 JTF_RS_RESOURCE_VALUES.ATTRIBUTE2%TYPE := p_attribute2;

484: L_VALUE_TYPE VARCHAR2 (30);
485: L_VALUE VARCHAR2 (255) := p_value;
486: L_OBJECT_VERSION_NUMBER JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE := p_object_version_number;
487: L_ATTRIBUTE1 JTF_RS_RESOURCE_VALUES.ATTRIBUTE1%TYPE := p_attribute1;
488: L_ATTRIBUTE2 JTF_RS_RESOURCE_VALUES.ATTRIBUTE2%TYPE := p_attribute2;
489: L_ATTRIBUTE3 JTF_RS_RESOURCE_VALUES.ATTRIBUTE3%TYPE := p_attribute3;
490: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;
491: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;
492: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;

Line 489: L_ATTRIBUTE3 JTF_RS_RESOURCE_VALUES.ATTRIBUTE3%TYPE := p_attribute3;

485: L_VALUE VARCHAR2 (255) := p_value;
486: L_OBJECT_VERSION_NUMBER JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE := p_object_version_number;
487: L_ATTRIBUTE1 JTF_RS_RESOURCE_VALUES.ATTRIBUTE1%TYPE := p_attribute1;
488: L_ATTRIBUTE2 JTF_RS_RESOURCE_VALUES.ATTRIBUTE2%TYPE := p_attribute2;
489: L_ATTRIBUTE3 JTF_RS_RESOURCE_VALUES.ATTRIBUTE3%TYPE := p_attribute3;
490: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;
491: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;
492: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;
493: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;

Line 490: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;

486: L_OBJECT_VERSION_NUMBER JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE := p_object_version_number;
487: L_ATTRIBUTE1 JTF_RS_RESOURCE_VALUES.ATTRIBUTE1%TYPE := p_attribute1;
488: L_ATTRIBUTE2 JTF_RS_RESOURCE_VALUES.ATTRIBUTE2%TYPE := p_attribute2;
489: L_ATTRIBUTE3 JTF_RS_RESOURCE_VALUES.ATTRIBUTE3%TYPE := p_attribute3;
490: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;
491: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;
492: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;
493: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;
494: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;

Line 491: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;

487: L_ATTRIBUTE1 JTF_RS_RESOURCE_VALUES.ATTRIBUTE1%TYPE := p_attribute1;
488: L_ATTRIBUTE2 JTF_RS_RESOURCE_VALUES.ATTRIBUTE2%TYPE := p_attribute2;
489: L_ATTRIBUTE3 JTF_RS_RESOURCE_VALUES.ATTRIBUTE3%TYPE := p_attribute3;
490: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;
491: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;
492: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;
493: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;
494: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;
495: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;

Line 492: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;

488: L_ATTRIBUTE2 JTF_RS_RESOURCE_VALUES.ATTRIBUTE2%TYPE := p_attribute2;
489: L_ATTRIBUTE3 JTF_RS_RESOURCE_VALUES.ATTRIBUTE3%TYPE := p_attribute3;
490: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;
491: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;
492: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;
493: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;
494: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;
495: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;
496: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;

Line 493: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;

489: L_ATTRIBUTE3 JTF_RS_RESOURCE_VALUES.ATTRIBUTE3%TYPE := p_attribute3;
490: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;
491: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;
492: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;
493: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;
494: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;
495: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;
496: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;
497: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;

Line 494: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;

490: L_ATTRIBUTE4 JTF_RS_RESOURCE_VALUES.ATTRIBUTE4%TYPE := p_attribute4;
491: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;
492: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;
493: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;
494: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;
495: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;
496: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;
497: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;
498: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;

Line 495: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;

491: L_ATTRIBUTE5 JTF_RS_RESOURCE_VALUES.ATTRIBUTE5%TYPE := p_attribute5;
492: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;
493: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;
494: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;
495: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;
496: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;
497: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;
498: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;
499: L_ATTRIBUTE13 JTF_RS_RESOURCE_VALUES.ATTRIBUTE13%TYPE := p_attribute13;

Line 496: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;

492: L_ATTRIBUTE6 JTF_RS_RESOURCE_VALUES.ATTRIBUTE6%TYPE := p_attribute6;
493: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;
494: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;
495: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;
496: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;
497: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;
498: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;
499: L_ATTRIBUTE13 JTF_RS_RESOURCE_VALUES.ATTRIBUTE13%TYPE := p_attribute13;
500: L_ATTRIBUTE14 JTF_RS_RESOURCE_VALUES.ATTRIBUTE14%TYPE := p_attribute14;

Line 497: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;

493: L_ATTRIBUTE7 JTF_RS_RESOURCE_VALUES.ATTRIBUTE7%TYPE := p_attribute7;
494: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;
495: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;
496: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;
497: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;
498: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;
499: L_ATTRIBUTE13 JTF_RS_RESOURCE_VALUES.ATTRIBUTE13%TYPE := p_attribute13;
500: L_ATTRIBUTE14 JTF_RS_RESOURCE_VALUES.ATTRIBUTE14%TYPE := p_attribute14;
501: L_ATTRIBUTE15 JTF_RS_RESOURCE_VALUES.ATTRIBUTE15%TYPE := p_attribute15;

Line 498: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;

494: L_ATTRIBUTE8 JTF_RS_RESOURCE_VALUES.ATTRIBUTE8%TYPE := p_attribute8;
495: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;
496: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;
497: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;
498: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;
499: L_ATTRIBUTE13 JTF_RS_RESOURCE_VALUES.ATTRIBUTE13%TYPE := p_attribute13;
500: L_ATTRIBUTE14 JTF_RS_RESOURCE_VALUES.ATTRIBUTE14%TYPE := p_attribute14;
501: L_ATTRIBUTE15 JTF_RS_RESOURCE_VALUES.ATTRIBUTE15%TYPE := p_attribute15;
502: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_VALUES.ATTRIBUTE_CATEGORY%TYPE := p_attribute_category;

Line 499: L_ATTRIBUTE13 JTF_RS_RESOURCE_VALUES.ATTRIBUTE13%TYPE := p_attribute13;

495: L_ATTRIBUTE9 JTF_RS_RESOURCE_VALUES.ATTRIBUTE9%TYPE := p_attribute9;
496: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;
497: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;
498: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;
499: L_ATTRIBUTE13 JTF_RS_RESOURCE_VALUES.ATTRIBUTE13%TYPE := p_attribute13;
500: L_ATTRIBUTE14 JTF_RS_RESOURCE_VALUES.ATTRIBUTE14%TYPE := p_attribute14;
501: L_ATTRIBUTE15 JTF_RS_RESOURCE_VALUES.ATTRIBUTE15%TYPE := p_attribute15;
502: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_VALUES.ATTRIBUTE_CATEGORY%TYPE := p_attribute_category;
503: L_BIND_DATA_ID NUMBER;

Line 500: L_ATTRIBUTE14 JTF_RS_RESOURCE_VALUES.ATTRIBUTE14%TYPE := p_attribute14;

496: L_ATTRIBUTE10 JTF_RS_RESOURCE_VALUES.ATTRIBUTE10%TYPE := p_attribute10;
497: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;
498: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;
499: L_ATTRIBUTE13 JTF_RS_RESOURCE_VALUES.ATTRIBUTE13%TYPE := p_attribute13;
500: L_ATTRIBUTE14 JTF_RS_RESOURCE_VALUES.ATTRIBUTE14%TYPE := p_attribute14;
501: L_ATTRIBUTE15 JTF_RS_RESOURCE_VALUES.ATTRIBUTE15%TYPE := p_attribute15;
502: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_VALUES.ATTRIBUTE_CATEGORY%TYPE := p_attribute_category;
503: L_BIND_DATA_ID NUMBER;
504:

Line 501: L_ATTRIBUTE15 JTF_RS_RESOURCE_VALUES.ATTRIBUTE15%TYPE := p_attribute15;

497: L_ATTRIBUTE11 JTF_RS_RESOURCE_VALUES.ATTRIBUTE11%TYPE := p_attribute11;
498: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;
499: L_ATTRIBUTE13 JTF_RS_RESOURCE_VALUES.ATTRIBUTE13%TYPE := p_attribute13;
500: L_ATTRIBUTE14 JTF_RS_RESOURCE_VALUES.ATTRIBUTE14%TYPE := p_attribute14;
501: L_ATTRIBUTE15 JTF_RS_RESOURCE_VALUES.ATTRIBUTE15%TYPE := p_attribute15;
502: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_VALUES.ATTRIBUTE_CATEGORY%TYPE := p_attribute_category;
503: L_BIND_DATA_ID NUMBER;
504:
505: CURSOR c_resource_param_value_id( l_resource_param_value_id IN NUMBER ) IS

Line 502: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_VALUES.ATTRIBUTE_CATEGORY%TYPE := p_attribute_category;

498: L_ATTRIBUTE12 JTF_RS_RESOURCE_VALUES.ATTRIBUTE12%TYPE := p_attribute12;
499: L_ATTRIBUTE13 JTF_RS_RESOURCE_VALUES.ATTRIBUTE13%TYPE := p_attribute13;
500: L_ATTRIBUTE14 JTF_RS_RESOURCE_VALUES.ATTRIBUTE14%TYPE := p_attribute14;
501: L_ATTRIBUTE15 JTF_RS_RESOURCE_VALUES.ATTRIBUTE15%TYPE := p_attribute15;
502: L_ATTRIBUTE_CATEGORY JTF_RS_RESOURCE_VALUES.ATTRIBUTE_CATEGORY%TYPE := p_attribute_category;
503: L_BIND_DATA_ID NUMBER;
504:
505: CURSOR c_resource_param_value_id( l_resource_param_value_id IN NUMBER ) IS
506: SELECT resource_param_value_id

Line 507: FROM jtf_rs_resource_values

503: L_BIND_DATA_ID NUMBER;
504:
505: CURSOR c_resource_param_value_id( l_resource_param_value_id IN NUMBER ) IS
506: SELECT resource_param_value_id
507: FROM jtf_rs_resource_values
508: WHERE resource_param_value_id = l_resource_param_value_id;
509:
510: CURSOR c_resource_param_value_update( l_resource_param_value_id IN NUMBER ) IS
511: SELECT

Line 529: FROM jtf_rs_resource_values

525: DECODE(p_attribute13,fnd_api.g_miss_char, attribute13, p_attribute13) l_attribute13,
526: DECODE(p_attribute14,fnd_api.g_miss_char, attribute14, p_attribute14) l_attribute14,
527: DECODE(p_attribute15,fnd_api.g_miss_char, attribute15, p_attribute15) l_attribute15,
528: DECODE(p_attribute_category,fnd_api.g_miss_char, attribute1, p_attribute_category) l_attribute_category
529: FROM jtf_rs_resource_values
530: WHERE resource_param_value_id = l_resource_param_value_id;
531:
532: resource_param_value_rec c_resource_param_value_update%ROWTYPE;
533:

Line 540: l_value1 jtf_rs_resource_values.value%TYPE;

536: from jtf_rs_resource_params
537: where resource_param_id = c_resource_param_id;
538:
539: l_type jtf_rs_resource_params.type%TYPE;
540: l_value1 jtf_rs_resource_values.value%TYPE;
541:
542: BEGIN
543:
544: SAVEPOINT update_rs_resource_values_pvt;

Line 558: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_param_value_id := l_resource_param_value_id;

554: END IF;
555:
556: --Initializing the Internal User Hook Record parameter values
557:
558: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_param_value_id := l_resource_param_value_id;
559: jtf_rs_resource_values_pub.p_rs_value_user_hook.value := l_value;
560:
561:
562: --Make the pre processing call to the user hooks

Line 559: jtf_rs_resource_values_pub.p_rs_value_user_hook.value := l_value;

555:
556: --Initializing the Internal User Hook Record parameter values
557:
558: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_param_value_id := l_resource_param_value_id;
559: jtf_rs_resource_values_pub.p_rs_value_user_hook.value := l_value;
560:
561:
562: --Make the pre processing call to the user hooks
563:

Line 567: 'JTF_RS_RESOURCE_VALUES_PVT',

563:
564: --Pre Call to the Customer Type User Hook
565:
566: IF jtf_usr_hks.ok_to_execute(
567: 'JTF_RS_RESOURCE_VALUES_PVT',
568: 'UPDATE_RS_RESOURCE_VALUES',
569: 'B',
570: 'C')
571: THEN

Line 572: jtf_rs_resource_values_cuhk.update_rs_resource_values_pre(

568: 'UPDATE_RS_RESOURCE_VALUES',
569: 'B',
570: 'C')
571: THEN
572: jtf_rs_resource_values_cuhk.update_rs_resource_values_pre(
573: P_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id,
574: P_VALUE => l_value,
575: X_RETURN_STATUS => x_return_status,
576: X_MSG_COUNT => x_msg_count,

Line 591: 'JTF_RS_RESOURCE_VALUES_PVT',

587:
588: --Pre Call to the Vertical Type User Hook
589:
590: IF jtf_usr_hks.ok_to_execute(
591: 'JTF_RS_RESOURCE_VALUES_PVT',
592: 'UPDATE_RS_RESOURCE_VALUES',
593: 'B',
594: 'V')
595: THEN

Line 596: jtf_rs_resource_values_vuhk.update_rs_resource_values_pre(

592: 'UPDATE_RS_RESOURCE_VALUES',
593: 'B',
594: 'V')
595: THEN
596: jtf_rs_resource_values_vuhk.update_rs_resource_values_pre(
597: P_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id,
598: P_VALUE => l_value,
599: X_RETURN_STATUS => x_return_status,
600: X_MSG_COUNT => x_msg_count,

Line 614: jtf_rs_resource_values_iuhk.update_rs_resource_values_pre(

610: END IF;
611:
612: --Pre Call to the Internal Type User Hook
613:
614: jtf_rs_resource_values_iuhk.update_rs_resource_values_pre(
615: X_RETURN_STATUS => x_return_status
616: );
617: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
618: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 654: FROM jtf_rs_resource_values

650:
651: --Get the Resource Param Id, Resource Id, Value Type from the database
652: SELECT resource_param_id, resource_id, value_type
653: INTO l_resource_param_id, l_resource_id, l_value_type
654: FROM jtf_rs_resource_values
655: WHERE resource_param_value_id = l_resource_param_value_id;
656:
657: --Validate Resource Value
658: IF p_value <> FND_API.G_MISS_CHAR THEN

Line 672: jtf_rs_resource_values_pkg.lock_row(

668: END IF;
669: --End of Resource Value Validation
670:
671: --Lock the row in the table by calling the table handler
672: jtf_rs_resource_values_pkg.lock_row(
673: X_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id,
674: X_OBJECT_VERSION_NUMBER => l_object_version_number
675: );
676:

Line 693: jtf_rs_resource_values_pkg.update_row(

689: l_value1 := resource_param_value_rec.l_value;
690: END IF;
691:
692: --Call the Table Handler to Update Values
693: jtf_rs_resource_values_pkg.update_row(
694: X_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id,
695: X_RESOURCE_ID => l_resource_id,
696: X_RESOURCE_PARAM_ID => l_resource_param_id,
697: X_VALUE => l_value1,

Line 730: fnd_vault.put(l_resource_param_value_id, 'JTF_RS_RESOURCE_VALUES', resource_param_value_rec.l_value);

726:
727: -- This is for bug fix # 3870910
728: -- Password will be stored using fnd_vault API
729: if (l_resource_param_value_id is NOT NULL and resource_param_value_rec.l_value is NOT NULL and l_type = 'PASSWORD') then
730: fnd_vault.put(l_resource_param_value_id, 'JTF_RS_RESOURCE_VALUES', resource_param_value_rec.l_value);
731: end if;
732:
733: --Make the post processing call to the user hooks
734:

Line 738: 'JTF_RS_RESOURCE_VALUES_PVT',

734:
735: --Post Call to the Customer Type User Hook
736:
737: IF jtf_usr_hks.ok_to_execute(
738: 'JTF_RS_RESOURCE_VALUES_PVT',
739: 'UPDATE_RS_RESOURCE_VALUES',
740: 'A',
741: 'C')
742: THEN

Line 743: jtf_rs_resource_values_cuhk.update_rs_resource_values_post(

739: 'UPDATE_RS_RESOURCE_VALUES',
740: 'A',
741: 'C')
742: THEN
743: jtf_rs_resource_values_cuhk.update_rs_resource_values_post(
744: P_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id,
745: P_VALUE => l_value,
746: X_RETURN_STATUS => x_return_status,
747: X_MSG_COUNT => x_msg_count,

Line 762: 'JTF_RS_RESOURCE_VALUES_PVT',

758:
759: --Post Call to the Vertical Type User Hook
760:
761: IF jtf_usr_hks.ok_to_execute(
762: 'JTF_RS_RESOURCE_VALUES_PVT',
763: 'UPDATE_RS_RESOURCE_VALUES',
764: 'A',
765: 'V')
766: THEN

Line 767: jtf_rs_resource_values_vuhk.update_rs_resource_values_post(

763: 'UPDATE_RS_RESOURCE_VALUES',
764: 'A',
765: 'V')
766: THEN
767: jtf_rs_resource_values_vuhk.update_rs_resource_values_post(
768: P_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id,
769: P_VALUE => l_value,
770: X_RETURN_STATUS => x_return_status,
771: X_MSG_COUNT => x_msg_count,

Line 785: jtf_rs_resource_values_iuhk.update_rs_resource_values_post(

781: END IF;
782:
783: --Post Call to the Internal Type User Hook
784:
785: jtf_rs_resource_values_iuhk.update_rs_resource_values_post(
786: X_RETURN_STATUS => x_return_status
787: );
788: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
789: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 798: 'JTF_RS_RESOURCE_VALUES_PVT',

794:
795: /* Standard call for Message Generation */
796:
797: IF jtf_usr_hks.ok_to_execute(
798: 'JTF_RS_RESOURCE_VALUES_PVT',
799: 'UPDATE_RS_RESOURCE_VALUES',
800: 'M',
801: 'M')
802: THEN

Line 803: IF (jtf_rs_resource_values_cuhk.ok_to_generate_msg(

799: 'UPDATE_RS_RESOURCE_VALUES',
800: 'M',
801: 'M')
802: THEN
803: IF (jtf_rs_resource_values_cuhk.ok_to_generate_msg(
804: p_resource_param_value_id => l_resource_param_value_id,
805: x_return_status => x_return_status) )
806: THEN
807:

Line 860: p_object_version_number IN JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE,

856: P_Api_Version IN NUMBER,
857: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
858: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
859: p_resource_param_value_id IN NUMBER,
860: p_object_version_number IN JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE,
861: X_Return_Status OUT NOCOPY VARCHAR2,
862: X_Msg_Count OUT NOCOPY NUMBER,
863: X_Msg_Data OUT NOCOPY VARCHAR2
864: )IS

Line 874: FROM jtf_rs_resource_values

870: l_bind_data_id NUMBER;
871:
872: CURSOR c_resource_param_value_id( l_resource_param_value_id IN NUMBER ) IS
873: SELECT resource_param_value_id
874: FROM jtf_rs_resource_values
875: WHERE resource_param_value_id = l_resource_param_value_id;
876:
877: BEGIN
878: SAVEPOINT delete_rs_resource_values_pvt;

Line 890: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_param_value_id := l_resource_param_value_id;

886: END IF;
887:
888: --Initializing the Internal User Hook Record parameter values
889:
890: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_param_value_id := l_resource_param_value_id;
891:
892: --Make the pre processing call to the user hooks
893:
894: --Pre Call to the Customer Type User Hook

Line 897: 'JTF_RS_RESOURCE_VALUES_PVT',

893:
894: --Pre Call to the Customer Type User Hook
895:
896: IF jtf_usr_hks.ok_to_execute(
897: 'JTF_RS_RESOURCE_VALUES_PVT',
898: 'DELETE_RS_RESOURCE_VALUES',
899: 'B',
900: 'C')
901: THEN

Line 902: jtf_rs_resource_values_cuhk.delete_rs_resource_values_pre(

898: 'DELETE_RS_RESOURCE_VALUES',
899: 'B',
900: 'C')
901: THEN
902: jtf_rs_resource_values_cuhk.delete_rs_resource_values_pre(
903: P_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id,
904: X_RETURN_STATUS => x_return_status,
905: X_MSG_COUNT => x_msg_count,
906: X_MSG_DATA => x_msg_data

Line 920: 'JTF_RS_RESOURCE_VALUES_PVT',

916:
917: --Pre Call to the Vertical Type User Hook
918:
919: IF jtf_usr_hks.ok_to_execute(
920: 'JTF_RS_RESOURCE_VALUES_PVT',
921: 'DELETE_RS_RESOURCE_VALUES',
922: 'B',
923: 'V')
924: THEN

Line 925: jtf_rs_resource_values_vuhk.delete_rs_resource_values_pre(

921: 'DELETE_RS_RESOURCE_VALUES',
922: 'B',
923: 'V')
924: THEN
925: jtf_rs_resource_values_vuhk.delete_rs_resource_values_pre(
926: P_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id,
927: X_RETURN_STATUS => x_return_status,
928: X_MSG_COUNT => x_msg_count,
929: X_MSG_DATA => x_msg_data

Line 942: jtf_rs_resource_values_iuhk.delete_rs_resource_values_pre(

938: END IF;
939:
940: --Pre Call to the Internal Type User Hook
941:
942: jtf_rs_resource_values_iuhk.delete_rs_resource_values_pre(
943: X_RETURN_STATUS => x_return_status
944: );
945:
946: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 970: jtf_rs_resource_values_pkg.lock_row(

966: END IF;
967:
968:
969: --Lock the row in the table before delete, by calling the table handler. */
970: jtf_rs_resource_values_pkg.lock_row(
971: X_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id,
972: X_OBJECT_VERSION_NUMBER => l_object_version_number
973: );
974:

Line 976: jtf_rs_resource_values_pkg.delete_row(

972: X_OBJECT_VERSION_NUMBER => l_object_version_number
973: );
974:
975: --Call Table Handler to Delete the Record
976: jtf_rs_resource_values_pkg.delete_row(
977: X_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id
978: );
979: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
980: --dbms_output.put_line('Failed status from call to table handler');

Line 989: 'JTF_RS_RESOURCE_VALUES_PVT',

985:
986: --Post Call to the Customer Type User Hook
987:
988: IF jtf_usr_hks.ok_to_execute(
989: 'JTF_RS_RESOURCE_VALUES_PVT',
990: 'DELETE_RS_RESOURCE_VALUES',
991: 'A',
992: 'C')
993: THEN

Line 994: jtf_rs_resource_values_cuhk.delete_rs_resource_values_post(

990: 'DELETE_RS_RESOURCE_VALUES',
991: 'A',
992: 'C')
993: THEN
994: jtf_rs_resource_values_cuhk.delete_rs_resource_values_post(
995: P_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id,
996: X_RETURN_STATUS => x_return_status,
997: X_MSG_COUNT => x_msg_count,
998: X_MSG_DATA => x_msg_data

Line 1012: 'JTF_RS_RESOURCE_VALUES_PVT',

1008:
1009: --Post Call to the Vertical Type User Hook
1010:
1011: IF jtf_usr_hks.ok_to_execute(
1012: 'JTF_RS_RESOURCE_VALUES_PVT',
1013: 'DELETE_RS_RESOURCE_VALUES',
1014: 'A',
1015: 'V')
1016: THEN

Line 1017: jtf_rs_resource_values_vuhk.delete_rs_resource_values_post(

1013: 'DELETE_RS_RESOURCE_VALUES',
1014: 'A',
1015: 'V')
1016: THEN
1017: jtf_rs_resource_values_vuhk.delete_rs_resource_values_post(
1018: P_RESOURCE_PARAM_VALUE_ID => l_resource_param_value_id,
1019: X_RETURN_STATUS => x_return_status,
1020: X_MSG_COUNT => x_msg_count,
1021: X_MSG_DATA => x_msg_data

Line 1034: jtf_rs_resource_values_iuhk.delete_rs_resource_values_post(

1030: END IF;
1031:
1032: --Post Call to the Internal Type User Hook
1033:
1034: jtf_rs_resource_values_iuhk.delete_rs_resource_values_post(
1035: X_RETURN_STATUS => x_return_status
1036: );
1037: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1038: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1047: 'JTF_RS_RESOURCE_VALUES_PVT',

1043:
1044: /* Standard call for Message Generation */
1045:
1046: IF jtf_usr_hks.ok_to_execute(
1047: 'JTF_RS_RESOURCE_VALUES_PVT',
1048: 'DELETE_RS_RESOURCE_VALUES',
1049: 'M',
1050: 'M')
1051: THEN

Line 1052: IF (jtf_rs_resource_values_cuhk.ok_to_generate_msg(

1048: 'DELETE_RS_RESOURCE_VALUES',
1049: 'M',
1050: 'M')
1051: THEN
1052: IF (jtf_rs_resource_values_cuhk.ok_to_generate_msg(
1053: p_resource_param_value_id => p_resource_param_value_id,
1054: x_return_status => x_return_status) )
1055: THEN
1056:

Line 1117: l_object_version_number JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE;

1113: l_api_version CONSTANT NUMBER := 1.0;
1114: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ALL_RS_RESOURCE_VALUES';
1115: l_resource_id NUMBER := p_resource_id;
1116: l_resource_param_value_id NUMBER;
1117: l_object_version_number JTF_RS_RESOURCE_VALUES.OBJECT_VERSION_NUMBER%TYPE;
1118: l_bind_data_id NUMBER;
1119: -- added to handle NOCOPY for JTF_RESOURCE_UTL package
1120: l_resource_id_out NUMBER;
1121:

Line 1124: FROM jtf_rs_resource_values jrv, jtf_rs_resource_params jrp

1120: l_resource_id_out NUMBER;
1121:
1122: CURSOR c_resource_param_value_id (l_resource_id IN NUMBER ) IS
1123: SELECT jrv.resource_param_value_id, jrv.object_version_number
1124: FROM jtf_rs_resource_values jrv, jtf_rs_resource_params jrp
1125: WHERE jrv.resource_param_id = jrp.resource_param_id
1126: AND jrp.application_id in ( 680, 172 )
1127: AND jrv.resource_id = l_resource_id;
1128:

Line 1142: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_id := l_resource_id;

1138: END IF;
1139:
1140: --Initializing the Internal User Hook Record parameter value
1141:
1142: jtf_rs_resource_values_pub.p_rs_value_user_hook.resource_id := l_resource_id;
1143:
1144: --Make the pre processing call to the user hooks
1145:
1146: --Pre Call to the Customer Type User Hook

Line 1149: 'JTF_RS_RESOURCE_VALUES_PVT',

1145:
1146: --Pre Call to the Customer Type User Hook
1147:
1148: IF jtf_usr_hks.ok_to_execute(
1149: 'JTF_RS_RESOURCE_VALUES_PVT',
1150: 'DELETE_ALL_RS_RESOURCE_VALUES',
1151: 'B',
1152: 'C')
1153: THEN

Line 1154: jtf_rs_resource_values_cuhk.delete_all_rs_values_pre(

1150: 'DELETE_ALL_RS_RESOURCE_VALUES',
1151: 'B',
1152: 'C')
1153: THEN
1154: jtf_rs_resource_values_cuhk.delete_all_rs_values_pre(
1155: P_RESOURCE_ID => l_resource_id,
1156: X_RETURN_STATUS => x_return_status,
1157: X_MSG_COUNT => x_msg_count,
1158: X_MSG_DATA => x_msg_data

Line 1172: 'JTF_RS_RESOURCE_VALUES_PVT',

1168:
1169: --Pre Call to the Vertical Type User Hook
1170:
1171: IF jtf_usr_hks.ok_to_execute(
1172: 'JTF_RS_RESOURCE_VALUES_PVT',
1173: 'DELETE_ALL_RS_RESOURCE_VALUES',
1174: 'B',
1175: 'V')
1176: THEN

Line 1177: jtf_rs_resource_values_vuhk.delete_all_rs_values_pre(

1173: 'DELETE_ALL_RS_RESOURCE_VALUES',
1174: 'B',
1175: 'V')
1176: THEN
1177: jtf_rs_resource_values_vuhk.delete_all_rs_values_pre(
1178: P_RESOURCE_ID => l_resource_id,
1179: X_RETURN_STATUS => x_return_status,
1180: X_MSG_COUNT => x_msg_count,
1181: X_MSG_DATA => x_msg_data

Line 1194: jtf_rs_resource_values_iuhk.delete_all_rs_values_pre(

1190: END IF;
1191:
1192: --Pre Call to the Internal Type User Hook
1193:
1194: jtf_rs_resource_values_iuhk.delete_all_rs_values_pre(
1195: X_RETURN_STATUS => x_return_status
1196: );
1197:
1198: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 1226: jtf_rs_resource_values_pkg.lock_row(

1222: --Loop through the Cursor and Delete all the entries for the given Resource ID
1223: FOR i IN c_resource_param_value_id (l_resource_id) LOOP
1224: --Call to the Lock_Row Table Handlers to lock the record before deleting it
1225: BEGIN
1226: jtf_rs_resource_values_pkg.lock_row(
1227: X_RESOURCE_PARAM_VALUE_ID => i.resource_param_value_id,
1228: X_OBJECT_VERSION_NUMBER => i.object_version_number
1229: );
1230: EXCEPTION

Line 1240: jtf_rs_resource_values_pkg.delete_row(

1236: RAISE fnd_api.g_exc_unexpected_error;
1237: END;
1238: --Call Table Handler to Delete the Selected Records
1239: BEGIN
1240: jtf_rs_resource_values_pkg.delete_row(
1241: X_RESOURCE_PARAM_VALUE_ID => i.resource_param_value_id
1242: );
1243: EXCEPTION
1244: WHEN NO_DATA_FOUND THEN

Line 1258: 'JTF_RS_RESOURCE_VALUES_PVT',

1254:
1255: --Post Call to the Customer Type User Hook
1256:
1257: IF jtf_usr_hks.ok_to_execute(
1258: 'JTF_RS_RESOURCE_VALUES_PVT',
1259: 'DELETE_ALL_RS_RESOURCE_VALUES',
1260: 'A',
1261: 'C')
1262: THEN

Line 1263: jtf_rs_resource_values_cuhk.delete_all_rs_values_post(

1259: 'DELETE_ALL_RS_RESOURCE_VALUES',
1260: 'A',
1261: 'C')
1262: THEN
1263: jtf_rs_resource_values_cuhk.delete_all_rs_values_post(
1264: P_RESOURCE_ID => l_resource_id,
1265: X_RETURN_STATUS => x_return_status,
1266: X_MSG_COUNT => x_msg_count,
1267: X_MSG_DATA => x_msg_data

Line 1281: 'JTF_RS_RESOURCE_VALUES_PVT',

1277:
1278: --Post Call to the Vertical Type User Hook
1279:
1280: IF jtf_usr_hks.ok_to_execute(
1281: 'JTF_RS_RESOURCE_VALUES_PVT',
1282: 'DELETE_ALL_RS_RESOURCE_VALUES',
1283: 'A',
1284: 'V')
1285: THEN

Line 1286: jtf_rs_resource_values_vuhk.delete_all_rs_values_post(

1282: 'DELETE_ALL_RS_RESOURCE_VALUES',
1283: 'A',
1284: 'V')
1285: THEN
1286: jtf_rs_resource_values_vuhk.delete_all_rs_values_post(
1287: P_RESOURCE_ID => l_resource_id,
1288: X_RETURN_STATUS => x_return_status,
1289: X_MSG_COUNT => x_msg_count,
1290: X_MSG_DATA => x_msg_data

Line 1303: jtf_rs_resource_values_iuhk.delete_all_rs_values_post(

1299: END IF;
1300:
1301: --Post Call to the Internal Type User Hook
1302:
1303: jtf_rs_resource_values_iuhk.delete_all_rs_values_post(
1304: X_RETURN_STATUS => x_return_status
1305: );
1306: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1307: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1361: FROM jtf_rs_resource_values

1357:
1358:
1359: CURSOR c_rs_resource_values IS
1360: SELECT resource_param_value_id, value
1361: FROM jtf_rs_resource_values
1362: WHERE resource_param_id = l_resource_param_id
1363: AND resource_id = l_resource_id
1364: AND ( (value_type = l_value_type) OR (l_value_type is null) );
1365:

Line 1464: X_RS_PARAM_Table OUT NOCOPY JTF_RS_RESOURCE_VALUES_PUB.RS_PARAM_LIST_TBL_TYPE,

1460: P_APPLICATION_ID IN NUMBER,
1461: X_Return_Status OUT NOCOPY VARCHAR2,
1462: X_Msg_Count OUT NOCOPY NUMBER,
1463: X_Msg_Data OUT NOCOPY VARCHAR2,
1464: X_RS_PARAM_Table OUT NOCOPY JTF_RS_RESOURCE_VALUES_PUB.RS_PARAM_LIST_TBL_TYPE,
1465: X_No_Record OUT NOCOPY NUMBER
1466: )IS
1467: l_api_version CONSTANT NUMBER := 1.0;
1468: l_api_name CONSTANT VARCHAR2(30) := 'GET_RS_RESOURCE_PARAM_LIST';

Line 1469: l_rs_param_rec JTF_RS_RESOURCE_VALUES_PUB.RS_PARAM_LIST_REC_TYPE;

1465: X_No_Record OUT NOCOPY NUMBER
1466: )IS
1467: l_api_version CONSTANT NUMBER := 1.0;
1468: l_api_name CONSTANT VARCHAR2(30) := 'GET_RS_RESOURCE_PARAM_LIST';
1469: l_rs_param_rec JTF_RS_RESOURCE_VALUES_PUB.RS_PARAM_LIST_REC_TYPE;
1470: l_tbl_counter NUMBER := 0;
1471: l_APPLICATION_ID NUMBER := P_APPLICATION_ID;
1472:
1473: CURSOR c_rs_resource_param_list IS

Line 1527: End JTF_RS_RESOURCE_VALUES_PVT;

1523: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1524:
1525: END get_rs_resource_param_list;
1526:
1527: End JTF_RS_RESOURCE_VALUES_PVT;