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.AD_PA_MISC dependencies on AD_PROGRAM_RUN_TASK_JOBS

Line 22: TYPE job_name IS TABLE OF ad_program_run_task_jobs.job_name%TYPE;

18: tsid number,
19: prd varchar2,
20: pname varchar2)
21: return number is
22: TYPE job_name IS TABLE OF ad_program_run_task_jobs.job_name%TYPE;
23: TYPE start_time IS TABLE OF ad_program_run_task_jobs.start_time%TYPE;
24: TYPE end_time IS TABLE OF ad_program_run_task_jobs.end_time%TYPE;
25:
26: l_job_name job_name;

Line 23: TYPE start_time IS TABLE OF ad_program_run_task_jobs.start_time%TYPE;

19: prd varchar2,
20: pname varchar2)
21: return number is
22: TYPE job_name IS TABLE OF ad_program_run_task_jobs.job_name%TYPE;
23: TYPE start_time IS TABLE OF ad_program_run_task_jobs.start_time%TYPE;
24: TYPE end_time IS TABLE OF ad_program_run_task_jobs.end_time%TYPE;
25:
26: l_job_name job_name;
27: l_start_time start_time;

Line 24: TYPE end_time IS TABLE OF ad_program_run_task_jobs.end_time%TYPE;

20: pname varchar2)
21: return number is
22: TYPE job_name IS TABLE OF ad_program_run_task_jobs.job_name%TYPE;
23: TYPE start_time IS TABLE OF ad_program_run_task_jobs.start_time%TYPE;
24: TYPE end_time IS TABLE OF ad_program_run_task_jobs.end_time%TYPE;
25:
26: l_job_name job_name;
27: l_start_time start_time;
28: l_end_time end_time;

Line 45: FROM ad_program_run_task_jobs

41: end_time
42: BULK COLLECT INTO l_job_name,
43: l_start_time,
44: l_end_time
45: FROM ad_program_run_task_jobs
46: WHERE program_run_id=prid
47: AND task_status_id=tsid
48: AND phase_name=pname
49: AND (product=prd OR