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

Line 41: l_id_column jtf_objects_b.select_id%TYPE;

37: )
38: IS
39: l_api_version CONSTANT NUMBER := 1.0;
40: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_REFERENCES';
41: l_id_column jtf_objects_b.select_id%TYPE;
42: l_name_column jtf_objects_b.select_name%TYPE;
43: l_from_clause jtf_objects_b.from_table%TYPE;
44: l_where_clause jtf_objects_b.where_clause%TYPE;
45: l_object_name jtf_task_references_b.object_name%TYPE;

Line 42: l_name_column jtf_objects_b.select_name%TYPE;

38: IS
39: l_api_version CONSTANT NUMBER := 1.0;
40: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_REFERENCES';
41: l_id_column jtf_objects_b.select_id%TYPE;
42: l_name_column jtf_objects_b.select_name%TYPE;
43: l_from_clause jtf_objects_b.from_table%TYPE;
44: l_where_clause jtf_objects_b.where_clause%TYPE;
45: l_object_name jtf_task_references_b.object_name%TYPE;
46: l_object_id jtf_task_references_b.object_id%TYPE;

Line 43: l_from_clause jtf_objects_b.from_table%TYPE;

39: l_api_version CONSTANT NUMBER := 1.0;
40: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_REFERENCES';
41: l_id_column jtf_objects_b.select_id%TYPE;
42: l_name_column jtf_objects_b.select_name%TYPE;
43: l_from_clause jtf_objects_b.from_table%TYPE;
44: l_where_clause jtf_objects_b.where_clause%TYPE;
45: l_object_name jtf_task_references_b.object_name%TYPE;
46: l_object_id jtf_task_references_b.object_id%TYPE;
47: l_task_reference_id NUMBER;

Line 44: l_where_clause jtf_objects_b.where_clause%TYPE;

40: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_REFERENCES';
41: l_id_column jtf_objects_b.select_id%TYPE;
42: l_name_column jtf_objects_b.select_name%TYPE;
43: l_from_clause jtf_objects_b.from_table%TYPE;
44: l_where_clause jtf_objects_b.where_clause%TYPE;
45: l_object_name jtf_task_references_b.object_name%TYPE;
46: l_object_id jtf_task_references_b.object_id%TYPE;
47: l_task_reference_id NUMBER;
48: l_rowid ROWID;

Line 53: l_object_type_code jtf_objects_b.object_code%TYPE := p_object_type_code;

49: l_task_id jtf_tasks_b.task_id%TYPE := p_task_id;
50: l_task_number jtf_tasks_b.task_number%TYPE := p_task_number;
51: sql_stmt VARCHAR2(4000);
52: x CHAR;
53: l_object_type_code jtf_objects_b.object_code%TYPE := p_object_type_code;
54:
55: CURSOR c_references
56: IS
57: SELECT select_id,

Line 421: l_id_column jtf_objects_b.select_id%TYPE;

417:
418:
419:
420:
421: l_id_column jtf_objects_b.select_id%TYPE;
422: l_name_column jtf_objects_b.select_name%TYPE;
423: l_from_clause jtf_objects_b.from_table%TYPE;
424: l_where_clause jtf_objects_b.where_clause%TYPE;
425: l_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_object_type_code;

Line 422: l_name_column jtf_objects_b.select_name%TYPE;

418:
419:
420:
421: l_id_column jtf_objects_b.select_id%TYPE;
422: l_name_column jtf_objects_b.select_name%TYPE;
423: l_from_clause jtf_objects_b.from_table%TYPE;
424: l_where_clause jtf_objects_b.where_clause%TYPE;
425: l_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_object_type_code;
426: l_object_name jtf_tasks_b.source_object_name%TYPE := p_object_name;

Line 423: l_from_clause jtf_objects_b.from_table%TYPE;

419:
420:
421: l_id_column jtf_objects_b.select_id%TYPE;
422: l_name_column jtf_objects_b.select_name%TYPE;
423: l_from_clause jtf_objects_b.from_table%TYPE;
424: l_where_clause jtf_objects_b.where_clause%TYPE;
425: l_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_object_type_code;
426: l_object_name jtf_tasks_b.source_object_name%TYPE := p_object_name;
427: l_object_id jtf_tasks_b.source_object_id%TYPE := p_object_id;

Line 424: l_where_clause jtf_objects_b.where_clause%TYPE;

420:
421: l_id_column jtf_objects_b.select_id%TYPE;
422: l_name_column jtf_objects_b.select_name%TYPE;
423: l_from_clause jtf_objects_b.from_table%TYPE;
424: l_where_clause jtf_objects_b.where_clause%TYPE;
425: l_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_object_type_code;
426: l_object_name jtf_tasks_b.source_object_name%TYPE := p_object_name;
427: l_object_id jtf_tasks_b.source_object_id%TYPE := p_object_id;
428: sql_stmt VARCHAR2(2000);

Line 532: l_object_type_code jtf_objects_b.object_code%TYPE := p_object_type_code;

528: l_api_version CONSTANT NUMBER := 1.0;
529: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_REFERENCES';
530:
531: l_task_id jtf_tasks_b.task_id%TYPE;
532: l_object_type_code jtf_objects_b.object_code%TYPE := p_object_type_code;
533: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE := p_task_reference_id;
534: l_reference_code jtf_task_references_b.reference_code%TYPE := p_reference_code;
535: l_usage jtf_task_references_tl.usage%TYPE := p_usage;
536: l_object_name jtf_task_references_b.object_name%TYPE;