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.AMS_TRACKING_PVT dependencies on AMS_SOURCE_CODES

Line 199: select source_code_id,arc_source_code_for into code_id,obj_type from ams_source_codes ascd where (ascd.source_code=p_track_rec.obj_src_code);

195: END IF;
196:
197: /* Bug fix:5594167 */
198:
199: select source_code_id,arc_source_code_for into code_id,obj_type from ams_source_codes ascd where (ascd.source_code=p_track_rec.obj_src_code);
200:
201: --IF (p_track_rec.obj_type = 'CSCH')
202: --THEN
203:

Line 227: -- select source_code_id into code_id from ams_source_codes ascd where (ascd.source_code=p_track_rec.obj_src_code); --Moving up

223: /* insert_log_mesg('l_resource_id' || l_resource_id);
224: insert_log_mesg('l_activity_id' || l_activity_id);
225: insert_log_mesg('l_activity_type' || l_activity_type); */
226:
227: -- select source_code_id into code_id from ams_source_codes ascd where (ascd.source_code=p_track_rec.obj_src_code); --Moving up
228:
229: /* End bug fix: 5594167 */
230:
231: if (l_activity_id = 40) then

Line 534: SELECT source_code_id FROM ams_source_codes

530: l_obj_src_code VARCHAR2(150);
531: l_code_id NUMBER := null;
532:
533: CURSOR c_code_id(p_code VARCHAR2) IS
534: SELECT source_code_id FROM ams_source_codes
535: WHERE source_code = p_code;
536:
537: BEGIN
538: