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.CS_INCIDENTLINKS_PVT dependencies on JTF_OBJECTS_VL

Line 501: -- the details got from JTF_OBJECTS_VL. Using the VL so as to select the

497: -- circular proc for message token.
498:
499: if ( p_validation_level = FND_API.G_VALID_LEVEL_NONE ) then
500: -- subject type is some valid type in JTF Object. Derive the number from
501: -- the details got from JTF_OBJECTS_VL. Using the VL so as to select the
502: -- name of the subject type for the message tokens
503: select select_id, select_name , from_table, name
504: into l_select_id, l_select_name, l_from_table, lx_subject_type_name
505: from jtf_objects_vl

Line 505: from jtf_objects_vl

501: -- the details got from JTF_OBJECTS_VL. Using the VL so as to select the
502: -- name of the subject type for the message tokens
503: select select_id, select_name , from_table, name
504: into l_select_id, l_select_name, l_from_table, lx_subject_type_name
505: from jtf_objects_vl
506: where object_code = p_link_rec.subject_type;
507:
508: -- use max to avoid the 'no data found' exception.
509: EXECUTE IMMEDIATE 'select max(' || l_select_name ||

Line 514: -- issue another select to jtf_objects_vl to get the object name.(check if

510: ') from ' || l_from_table||
511: ' where ' || l_select_id || ' = :p1'
512: INTO lx_subject_number USING p_link_rec.subject_id;
513:
514: -- issue another select to jtf_objects_vl to get the object name.(check if
515: -- use of cursor will help for the two select to jtf_objects_vl
516: select max(name)
517: into lx_object_type_name
518: from jtf_objects_vl

Line 515: -- use of cursor will help for the two select to jtf_objects_vl

511: ' where ' || l_select_id || ' = :p1'
512: INTO lx_subject_number USING p_link_rec.subject_id;
513:
514: -- issue another select to jtf_objects_vl to get the object name.(check if
515: -- use of cursor will help for the two select to jtf_objects_vl
516: select max(name)
517: into lx_object_type_name
518: from jtf_objects_vl
519: where object_code = p_link_rec.object_type;

Line 518: from jtf_objects_vl

514: -- issue another select to jtf_objects_vl to get the object name.(check if
515: -- use of cursor will help for the two select to jtf_objects_vl
516: select max(name)
517: into lx_object_type_name
518: from jtf_objects_vl
519: where object_code = p_link_rec.object_type;
520:
521: -- store the passed in object_number into lx_object_number for circular message
522: lx_object_number := p_link_rec.object_number;