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.AHL_RM_ROUTE_UTIL dependencies on JTF_TASK_TEMP_GROUPS_VL

Line 1192: p_task_template_group IN JTF_TASK_TEMP_GROUPS_VL.template_group_name%TYPE,

1188: PROCEDURE validate_task_template_group
1189: (
1190: x_return_status OUT NOCOPY VARCHAR2,
1191: x_msg_data OUT NOCOPY VARCHAR2,
1192: p_task_template_group IN JTF_TASK_TEMP_GROUPS_VL.template_group_name%TYPE,
1193: p_x_task_template_group_id IN OUT NOCOPY JTF_TASK_TEMP_GROUPS_VL.task_template_group_id%TYPE
1194: )
1195: IS
1196:

Line 1193: p_x_task_template_group_id IN OUT NOCOPY JTF_TASK_TEMP_GROUPS_VL.task_template_group_id%TYPE

1189: (
1190: x_return_status OUT NOCOPY VARCHAR2,
1191: x_msg_data OUT NOCOPY VARCHAR2,
1192: p_task_template_group IN JTF_TASK_TEMP_GROUPS_VL.template_group_name%TYPE,
1193: p_x_task_template_group_id IN OUT NOCOPY JTF_TASK_TEMP_GROUPS_VL.task_template_group_id%TYPE
1194: )
1195: IS
1196:
1197: l_task_template_group_id JTF_TASK_TEMP_GROUPS_VL.task_template_group_id%TYPE;

Line 1197: l_task_template_group_id JTF_TASK_TEMP_GROUPS_VL.task_template_group_id%TYPE;

1193: p_x_task_template_group_id IN OUT NOCOPY JTF_TASK_TEMP_GROUPS_VL.task_template_group_id%TYPE
1194: )
1195: IS
1196:
1197: l_task_template_group_id JTF_TASK_TEMP_GROUPS_VL.task_template_group_id%TYPE;
1198:
1199: CURSOR get_rec_from_value ( c_task_template_group JTF_TASK_TEMP_GROUPS_VL.template_group_name%TYPE )
1200: IS
1201: SELECT DISTINCT task_template_group_id

Line 1199: CURSOR get_rec_from_value ( c_task_template_group JTF_TASK_TEMP_GROUPS_VL.template_group_name%TYPE )

1195: IS
1196:
1197: l_task_template_group_id JTF_TASK_TEMP_GROUPS_VL.task_template_group_id%TYPE;
1198:
1199: CURSOR get_rec_from_value ( c_task_template_group JTF_TASK_TEMP_GROUPS_VL.template_group_name%TYPE )
1200: IS
1201: SELECT DISTINCT task_template_group_id
1202: FROM JTF_TASK_TEMP_GROUPS_VL
1203: WHERE trunc(sysdate) >= trunc(nvl(start_date_active, sysdate)) and

Line 1202: FROM JTF_TASK_TEMP_GROUPS_VL

1198:
1199: CURSOR get_rec_from_value ( c_task_template_group JTF_TASK_TEMP_GROUPS_VL.template_group_name%TYPE )
1200: IS
1201: SELECT DISTINCT task_template_group_id
1202: FROM JTF_TASK_TEMP_GROUPS_VL
1203: WHERE trunc(sysdate) >= trunc(nvl(start_date_active, sysdate)) and
1204: trunc(sysdate) < trunc(nvl(end_date_active, sysdate+1)) and
1205: template_group_name = c_task_template_group;
1206:

Line 1207: CURSOR get_rec_from_id ( c_task_template_group_id JTF_TASK_TEMP_GROUPS_VL.task_template_group_id%TYPE )

1203: WHERE trunc(sysdate) >= trunc(nvl(start_date_active, sysdate)) and
1204: trunc(sysdate) < trunc(nvl(end_date_active, sysdate+1)) and
1205: template_group_name = c_task_template_group;
1206:
1207: CURSOR get_rec_from_id ( c_task_template_group_id JTF_TASK_TEMP_GROUPS_VL.task_template_group_id%TYPE )
1208: IS
1209: SELECT DISTINCT task_template_group_id
1210: FROM JTF_TASK_TEMP_GROUPS_VL
1211: WHERE trunc(sysdate) >= trunc(nvl(start_date_active, sysdate)) and

Line 1210: FROM JTF_TASK_TEMP_GROUPS_VL

1206:
1207: CURSOR get_rec_from_id ( c_task_template_group_id JTF_TASK_TEMP_GROUPS_VL.task_template_group_id%TYPE )
1208: IS
1209: SELECT DISTINCT task_template_group_id
1210: FROM JTF_TASK_TEMP_GROUPS_VL
1211: WHERE trunc(sysdate) >= trunc(nvl(start_date_active, sysdate)) and
1212: trunc(sysdate) < trunc(nvl(end_date_active, sysdate+1)) and
1213: task_template_group_id = c_task_template_group_id;
1214: