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_TASK_UTL dependencies on JTF_OBJECTS_B

Line 411: FROM jtf_objects_b

407: IS
408: CURSOR c_references
409: IS
410: SELECT select_id, select_name, from_table, where_clause
411: FROM jtf_objects_b
412: WHERE object_code = p_object_type_code;
413: --- Removed the reference from JTF_OBJECTS_VL to JT_OBJECTS_B.
414:
415:

Line 416: l_id_column jtf_objects_b.select_id%TYPE;

412: WHERE object_code = p_object_type_code;
413: --- Removed the reference from JTF_OBJECTS_VL to JT_OBJECTS_B.
414:
415:
416: l_id_column jtf_objects_b.select_id%TYPE;
417: l_name_column jtf_objects_b.select_name%TYPE;
418: l_from_clause jtf_objects_b.from_table%TYPE;
419: l_where_clause jtf_objects_b.where_clause%TYPE;
420: l_object_code jtf_tasks_b.source_object_type_code%TYPE

Line 417: l_name_column jtf_objects_b.select_name%TYPE;

413: --- Removed the reference from JTF_OBJECTS_VL to JT_OBJECTS_B.
414:
415:
416: l_id_column jtf_objects_b.select_id%TYPE;
417: l_name_column jtf_objects_b.select_name%TYPE;
418: l_from_clause jtf_objects_b.from_table%TYPE;
419: l_where_clause jtf_objects_b.where_clause%TYPE;
420: l_object_code jtf_tasks_b.source_object_type_code%TYPE
421: := p_object_type_code;

Line 418: l_from_clause jtf_objects_b.from_table%TYPE;

414:
415:
416: l_id_column jtf_objects_b.select_id%TYPE;
417: l_name_column jtf_objects_b.select_name%TYPE;
418: l_from_clause jtf_objects_b.from_table%TYPE;
419: l_where_clause jtf_objects_b.where_clause%TYPE;
420: l_object_code jtf_tasks_b.source_object_type_code%TYPE
421: := p_object_type_code;
422: l_object_name VARCHAR2(2000);

Line 419: l_where_clause jtf_objects_b.where_clause%TYPE;

415:
416: l_id_column jtf_objects_b.select_id%TYPE;
417: l_name_column jtf_objects_b.select_name%TYPE;
418: l_from_clause jtf_objects_b.from_table%TYPE;
419: l_where_clause jtf_objects_b.where_clause%TYPE;
420: l_object_code jtf_tasks_b.source_object_type_code%TYPE
421: := p_object_type_code;
422: l_object_name VARCHAR2(2000);
423: l_object_id jtf_tasks_b.source_object_id%TYPE

Line 708: FROM jtf_objects_b

704: IS
705: CURSOR c_object_code
706: IS
707: SELECT object_code
708: FROM jtf_objects_b
709: WHERE object_code = p_object_code
710: AND trunc(NVL (end_date_active, SYSDATE)) >= trunc(SYSDATE)
711: AND trunc(NVL (start_date_active, SYSDATE)) <= trunc(SYSDATE)
712: AND (object_code IN

Line 1336: FROM jtf_objects_b

1332: IS
1333: CURSOR c_references
1334: IS
1335: SELECT select_id, select_name, from_table, where_clause
1336: FROM jtf_objects_b
1337: WHERE object_code = p_object_code
1338: AND object_code IN (SELECT object_code
1339: FROM jtf_object_usages
1340: WHERE object_user_code = 'TASK');

Line 1343: l_id_column jtf_objects_b.select_id%TYPE;

1339: FROM jtf_object_usages
1340: WHERE object_user_code = 'TASK');
1341:
1342:
1343: l_id_column jtf_objects_b.select_id%TYPE;
1344: l_name_column jtf_objects_b.select_name%TYPE;
1345: l_from_clause jtf_objects_b.from_table%TYPE;
1346: l_where_clause jtf_objects_b.where_clause%TYPE;
1347: l_object_code jtf_tasks_b.source_object_type_code%TYPE

Line 1344: l_name_column jtf_objects_b.select_name%TYPE;

1340: WHERE object_user_code = 'TASK');
1341:
1342:
1343: l_id_column jtf_objects_b.select_id%TYPE;
1344: l_name_column jtf_objects_b.select_name%TYPE;
1345: l_from_clause jtf_objects_b.from_table%TYPE;
1346: l_where_clause jtf_objects_b.where_clause%TYPE;
1347: l_object_code jtf_tasks_b.source_object_type_code%TYPE
1348: := p_object_code;

Line 1345: l_from_clause jtf_objects_b.from_table%TYPE;

1341:
1342:
1343: l_id_column jtf_objects_b.select_id%TYPE;
1344: l_name_column jtf_objects_b.select_name%TYPE;
1345: l_from_clause jtf_objects_b.from_table%TYPE;
1346: l_where_clause jtf_objects_b.where_clause%TYPE;
1347: l_object_code jtf_tasks_b.source_object_type_code%TYPE
1348: := p_object_code;
1349: --Fix bug 2430516, when EXECUTE IMMEDIATE sql_stmt below, the length of

Line 1346: l_where_clause jtf_objects_b.where_clause%TYPE;

1342:
1343: l_id_column jtf_objects_b.select_id%TYPE;
1344: l_name_column jtf_objects_b.select_name%TYPE;
1345: l_from_clause jtf_objects_b.from_table%TYPE;
1346: l_where_clause jtf_objects_b.where_clause%TYPE;
1347: l_object_code jtf_tasks_b.source_object_type_code%TYPE
1348: := p_object_code;
1349: --Fix bug 2430516, when EXECUTE IMMEDIATE sql_stmt below, the length of
1350: --l_object_name could exceed 80 chars

Line 2195: FROM jtf_objects_b

2191: IS
2192: CURSOR c_object_code
2193: IS
2194: SELECT object_code
2195: FROM jtf_objects_b
2196: WHERE object_code = p_object_code;
2197:
2198: CURSOR c_object_type_name
2199: IS

Line 2245: l_owner_type_code jtf_objects_b.object_code%TYPE

2241: x_owner_id IN OUT NOCOPY NUMBER, -- Fixed from OUT to IN OUT
2242: x_owner_type_code IN OUT NOCOPY VARCHAR2 -- Fixed from OUT to IN OUT
2243: )
2244: IS
2245: l_owner_type_code jtf_objects_b.object_code%TYPE
2246: := p_owner_type_code;
2247: l_owner_type_name jtf_objects_tl.name%TYPE
2248: := p_owner_type_name;
2249: l_id_column jtf_objects_b.select_id%TYPE;

Line 2249: l_id_column jtf_objects_b.select_id%TYPE;

2245: l_owner_type_code jtf_objects_b.object_code%TYPE
2246: := p_owner_type_code;
2247: l_owner_type_name jtf_objects_tl.name%TYPE
2248: := p_owner_type_name;
2249: l_id_column jtf_objects_b.select_id%TYPE;
2250: l_from_clause jtf_objects_b.from_table%TYPE;
2251: l_where_clause jtf_objects_b.where_clause%TYPE;
2252: sql_stmt VARCHAR2(4000);
2253: l_owner_id jtf_tasks_b.owner_id%TYPE := p_owner_id;

Line 2250: l_from_clause jtf_objects_b.from_table%TYPE;

2246: := p_owner_type_code;
2247: l_owner_type_name jtf_objects_tl.name%TYPE
2248: := p_owner_type_name;
2249: l_id_column jtf_objects_b.select_id%TYPE;
2250: l_from_clause jtf_objects_b.from_table%TYPE;
2251: l_where_clause jtf_objects_b.where_clause%TYPE;
2252: sql_stmt VARCHAR2(4000);
2253: l_owner_id jtf_tasks_b.owner_id%TYPE := p_owner_id;
2254:

Line 2251: l_where_clause jtf_objects_b.where_clause%TYPE;

2247: l_owner_type_name jtf_objects_tl.name%TYPE
2248: := p_owner_type_name;
2249: l_id_column jtf_objects_b.select_id%TYPE;
2250: l_from_clause jtf_objects_b.from_table%TYPE;
2251: l_where_clause jtf_objects_b.where_clause%TYPE;
2252: sql_stmt VARCHAR2(4000);
2253: l_owner_id jtf_tasks_b.owner_id%TYPE := p_owner_id;
2254:
2255: CURSOR c_owner_type

Line 2259: FROM jtf_objects_b

2255: CURSOR c_owner_type
2256: IS
2257:
2258: SELECT select_id, from_table, where_clause
2259: FROM jtf_objects_b
2260: WHERE object_code = l_owner_type_code;
2261: BEGIN
2262: x_return_status := fnd_api.g_ret_sts_success;
2263: jtf_task_utl.validate_object_type (

Line 3796: from jtf_objects_b

3792: as
3793: l_object_parameters varchar2(60);
3794: begin
3795: select OBJECT_PARAMETERS into l_object_parameters
3796: from jtf_objects_b
3797: where object_code = p_object_code ;
3798:
3799: return l_object_parameters ;
3800: end ;

Line 4624: FROM jtf_objects_b

4620: IS
4621: CURSOR c_references
4622: IS
4623: SELECT select_id, select_details, from_table, where_clause
4624: FROM jtf_objects_b
4625: WHERE object_code = p_object_type_code;
4626: --- Removed the reference from JTF_OBJECTS_VL to JT_OBJECTS_B.
4627:
4628:

Line 4629: l_id_column jtf_objects_b.select_id%TYPE;

4625: WHERE object_code = p_object_type_code;
4626: --- Removed the reference from JTF_OBJECTS_VL to JT_OBJECTS_B.
4627:
4628:
4629: l_id_column jtf_objects_b.select_id%TYPE;
4630: l_details_column jtf_objects_b.select_details%TYPE;
4631: l_from_clause jtf_objects_b.from_table%TYPE;
4632: l_where_clause jtf_objects_b.where_clause%TYPE;
4633: l_object_code jtf_tasks_b.source_object_type_code%TYPE

Line 4630: l_details_column jtf_objects_b.select_details%TYPE;

4626: --- Removed the reference from JTF_OBJECTS_VL to JT_OBJECTS_B.
4627:
4628:
4629: l_id_column jtf_objects_b.select_id%TYPE;
4630: l_details_column jtf_objects_b.select_details%TYPE;
4631: l_from_clause jtf_objects_b.from_table%TYPE;
4632: l_where_clause jtf_objects_b.where_clause%TYPE;
4633: l_object_code jtf_tasks_b.source_object_type_code%TYPE
4634: := p_object_type_code;

Line 4631: l_from_clause jtf_objects_b.from_table%TYPE;

4627:
4628:
4629: l_id_column jtf_objects_b.select_id%TYPE;
4630: l_details_column jtf_objects_b.select_details%TYPE;
4631: l_from_clause jtf_objects_b.from_table%TYPE;
4632: l_where_clause jtf_objects_b.where_clause%TYPE;
4633: l_object_code jtf_tasks_b.source_object_type_code%TYPE
4634: := p_object_type_code;
4635: l_object_details VARCHAR2(2000);

Line 4632: l_where_clause jtf_objects_b.where_clause%TYPE;

4628:
4629: l_id_column jtf_objects_b.select_id%TYPE;
4630: l_details_column jtf_objects_b.select_details%TYPE;
4631: l_from_clause jtf_objects_b.from_table%TYPE;
4632: l_where_clause jtf_objects_b.where_clause%TYPE;
4633: l_object_code jtf_tasks_b.source_object_type_code%TYPE
4634: := p_object_type_code;
4635: l_object_details VARCHAR2(2000);
4636: is_null BOOLEAN := FALSE;