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_CAL_GRANTS_PVT dependencies on JTF_TASK_SECURITY_PVT

Line 33: where instance_set_name = jtf_task_security_pvt.RESOURCE_TASKS_SET;

29: IS
30: l_instance_set_id NUMBER;
31: CURSOR C_INSTANCE_SET_ID IS
32: select instance_set_id from fnd_object_instance_sets
33: where instance_set_name = jtf_task_security_pvt.RESOURCE_TASKS_SET;
34: BEGIN
35: OPEN C_INSTANCE_SET_ID;
36: FETCH C_INSTANCE_SET_ID INTO l_instance_set_id;
37: IF (C_INSTANCE_SET_ID %NOTFOUND) THEN

Line 115: , p_object_name => jtf_task_security_pvt.TASK_OBJECT

111: fnd_grants_pkg.grant_function( p_api_version => api_version
112: , p_menu_name => menu_name
113: , p_instance_type => TASK_INSTANCE_TYPE
114: , p_instance_set_id => l_instance_set_id
115: , p_object_name => jtf_task_security_pvt.TASK_OBJECT
116: , p_grantee_type => GRANTEE_TYPE
117: , p_grantee_key => grantee_key
118: , p_start_date => SYSDATE
119: , p_end_date => NULL

Line 195: AND fos.obj_name = jtf_task_security_pvt.TASK_OBJECT

191: CURSOR C_TASKS IS
192: SELECT fgs.grant_guid, fgs.grantee_key, fmu.menu_name
193: FROM FND_GRANTS fgs, FND_MENUS fmu, FND_OBJECTS fos
194: WHERE fgs.object_id = fos.object_id
195: AND fos.obj_name = jtf_task_security_pvt.TASK_OBJECT
196: AND fgs.menu_id = fmu.menu_id
197: AND fmu.menu_name IN (jtf_task_security_pvt.READ_PRIVILEGE
198: ,jtf_task_security_pvt.FULL_PRIVILEGE
199: ) -- Task Read and Full Access

Line 197: AND fmu.menu_name IN (jtf_task_security_pvt.READ_PRIVILEGE

193: FROM FND_GRANTS fgs, FND_MENUS fmu, FND_OBJECTS fos
194: WHERE fgs.object_id = fos.object_id
195: AND fos.obj_name = jtf_task_security_pvt.TASK_OBJECT
196: AND fgs.menu_id = fmu.menu_id
197: AND fmu.menu_name IN (jtf_task_security_pvt.READ_PRIVILEGE
198: ,jtf_task_security_pvt.FULL_PRIVILEGE
199: ) -- Task Read and Full Access
200: AND instance_type = TASK_INSTANCE_TYPE
201: AND instance_set_id = l_instance_set_id

Line 198: ,jtf_task_security_pvt.FULL_PRIVILEGE

194: WHERE fgs.object_id = fos.object_id
195: AND fos.obj_name = jtf_task_security_pvt.TASK_OBJECT
196: AND fgs.menu_id = fmu.menu_id
197: AND fmu.menu_name IN (jtf_task_security_pvt.READ_PRIVILEGE
198: ,jtf_task_security_pvt.FULL_PRIVILEGE
199: ) -- Task Read and Full Access
200: AND instance_type = TASK_INSTANCE_TYPE
201: AND instance_set_id = l_instance_set_id
202: AND parameter1 = p_GranterID

Line 268: l_TaskAccessTbl(i).AccessLevel := jtf_task_security_pvt.READ_PRIVILEGE;

264: fnd_msg_pub.add;
265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
266: END IF;
267:
268: l_TaskAccessTbl(i).AccessLevel := jtf_task_security_pvt.READ_PRIVILEGE;
269:
270: i := i + 1;
271: l_index1 := l_index2 + 1;
272: IF (l_index2 > length(p_ReadAccess))

Line 306: l_TaskAccessTbl(i).AccessLevel := jtf_task_security_pvt.FULL_PRIVILEGE;

302: fnd_msg_pub.add;
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:
306: l_TaskAccessTbl(i).AccessLevel := jtf_task_security_pvt.FULL_PRIVILEGE;
307:
308: i := i + 1;
309: j := j + 1;
310: l_index1 := l_index2 + 1;

Line 319: l_instance_set_id := get_instance_set_id(jtf_task_security_pvt.RESOURCE_TASKS_SET);

315: END LOOP FULL_ACCESS;
316:
317: /** Get the instance_set_id for instance_name RESOURCE_TASKS_SET **/
318: /** It is required in fnd_grants function **/
319: l_instance_set_id := get_instance_set_id(jtf_task_security_pvt.RESOURCE_TASKS_SET);
320: IF ( l_instance_set_id = -1) THEN
321: fnd_message.set_name('JTF', 'JTF_CAL_INST_SET_ID_NOT_FOUND');
322: fnd_msg_pub.add;
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 382: IF ((l_TaskAccessTbl(n).GrantType = 1) AND (l_TaskAccessTbl(n).AccessLevel= jtf_task_security_pvt.READ_PRIVILEGE) ) THEN

378:
379:
380: FOR n IN 1 .. NVL(l_TaskAccessTbl.LAST,0)
381: LOOP <>
382: IF ((l_TaskAccessTbl(n).GrantType = 1) AND (l_TaskAccessTbl(n).AccessLevel= jtf_task_security_pvt.READ_PRIVILEGE) ) THEN
383: /** Grant Tasks Read Access **/
384: doTasksGrant(l_api_version,jtf_task_security_pvt.READ_PRIVILEGE,l_instance_set_id, p_GranterID,l_TaskAccessTbl(n).GranteeKey);
385: ELSIF ((l_TaskAccessTbl(n).GrantType = 1) AND (l_TaskAccessTbl(n).AccessLevel=jtf_task_security_pvt.FULL_PRIVILEGE) ) THEN
386: /** Grant Tasks Full Access **/

Line 384: doTasksGrant(l_api_version,jtf_task_security_pvt.READ_PRIVILEGE,l_instance_set_id, p_GranterID,l_TaskAccessTbl(n).GranteeKey);

380: FOR n IN 1 .. NVL(l_TaskAccessTbl.LAST,0)
381: LOOP <>
382: IF ((l_TaskAccessTbl(n).GrantType = 1) AND (l_TaskAccessTbl(n).AccessLevel= jtf_task_security_pvt.READ_PRIVILEGE) ) THEN
383: /** Grant Tasks Read Access **/
384: doTasksGrant(l_api_version,jtf_task_security_pvt.READ_PRIVILEGE,l_instance_set_id, p_GranterID,l_TaskAccessTbl(n).GranteeKey);
385: ELSIF ((l_TaskAccessTbl(n).GrantType = 1) AND (l_TaskAccessTbl(n).AccessLevel=jtf_task_security_pvt.FULL_PRIVILEGE) ) THEN
386: /** Grant Tasks Full Access **/
387: doTasksGrant(l_api_version,jtf_task_security_pvt.FULL_PRIVILEGE,l_instance_set_id, p_GranterID,l_TaskAccessTbl(n).GranteeKey);
388: END IF;

Line 385: ELSIF ((l_TaskAccessTbl(n).GrantType = 1) AND (l_TaskAccessTbl(n).AccessLevel=jtf_task_security_pvt.FULL_PRIVILEGE) ) THEN

381: LOOP <>
382: IF ((l_TaskAccessTbl(n).GrantType = 1) AND (l_TaskAccessTbl(n).AccessLevel= jtf_task_security_pvt.READ_PRIVILEGE) ) THEN
383: /** Grant Tasks Read Access **/
384: doTasksGrant(l_api_version,jtf_task_security_pvt.READ_PRIVILEGE,l_instance_set_id, p_GranterID,l_TaskAccessTbl(n).GranteeKey);
385: ELSIF ((l_TaskAccessTbl(n).GrantType = 1) AND (l_TaskAccessTbl(n).AccessLevel=jtf_task_security_pvt.FULL_PRIVILEGE) ) THEN
386: /** Grant Tasks Full Access **/
387: doTasksGrant(l_api_version,jtf_task_security_pvt.FULL_PRIVILEGE,l_instance_set_id, p_GranterID,l_TaskAccessTbl(n).GranteeKey);
388: END IF;
389: END LOOP ADD_TASKS_ACCESS;

Line 387: doTasksGrant(l_api_version,jtf_task_security_pvt.FULL_PRIVILEGE,l_instance_set_id, p_GranterID,l_TaskAccessTbl(n).GranteeKey);

383: /** Grant Tasks Read Access **/
384: doTasksGrant(l_api_version,jtf_task_security_pvt.READ_PRIVILEGE,l_instance_set_id, p_GranterID,l_TaskAccessTbl(n).GranteeKey);
385: ELSIF ((l_TaskAccessTbl(n).GrantType = 1) AND (l_TaskAccessTbl(n).AccessLevel=jtf_task_security_pvt.FULL_PRIVILEGE) ) THEN
386: /** Grant Tasks Full Access **/
387: doTasksGrant(l_api_version,jtf_task_security_pvt.FULL_PRIVILEGE,l_instance_set_id, p_GranterID,l_TaskAccessTbl(n).GranteeKey);
388: END IF;
389: END LOOP ADD_TASKS_ACCESS;
390:
391: /*****************************************************************************