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 1186: p_task_template_group IN JTF_TASK_TEMP_GROUPS_VL.template_group_name%TYPE,

1182: PROCEDURE validate_task_template_group
1183: (
1184: x_return_status OUT NOCOPY VARCHAR2,
1185: x_msg_data OUT NOCOPY VARCHAR2,
1186: p_task_template_group IN JTF_TASK_TEMP_GROUPS_VL.template_group_name%TYPE,
1187: p_x_task_template_group_id IN OUT NOCOPY JTF_TASK_TEMP_GROUPS_VL.task_template_group_id%TYPE
1188: )
1189: IS
1190:

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

1183: (
1184: x_return_status OUT NOCOPY VARCHAR2,
1185: x_msg_data OUT NOCOPY VARCHAR2,
1186: p_task_template_group IN JTF_TASK_TEMP_GROUPS_VL.template_group_name%TYPE,
1187: p_x_task_template_group_id IN OUT NOCOPY JTF_TASK_TEMP_GROUPS_VL.task_template_group_id%TYPE
1188: )
1189: IS
1190:
1191: l_task_template_group_id JTF_TASK_TEMP_GROUPS_VL.task_template_group_id%TYPE;

Line 1191: l_task_template_group_id JTF_TASK_TEMP_GROUPS_VL.task_template_group_id%TYPE;

1187: p_x_task_template_group_id IN OUT NOCOPY JTF_TASK_TEMP_GROUPS_VL.task_template_group_id%TYPE
1188: )
1189: IS
1190:
1191: l_task_template_group_id JTF_TASK_TEMP_GROUPS_VL.task_template_group_id%TYPE;
1192:
1193: CURSOR get_rec_from_value ( c_task_template_group JTF_TASK_TEMP_GROUPS_VL.template_group_name%TYPE )
1194: IS
1195: SELECT DISTINCT task_template_group_id

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

1189: IS
1190:
1191: l_task_template_group_id JTF_TASK_TEMP_GROUPS_VL.task_template_group_id%TYPE;
1192:
1193: CURSOR get_rec_from_value ( c_task_template_group JTF_TASK_TEMP_GROUPS_VL.template_group_name%TYPE )
1194: IS
1195: SELECT DISTINCT task_template_group_id
1196: FROM JTF_TASK_TEMP_GROUPS_VL
1197: WHERE trunc(sysdate) >= trunc(nvl(start_date_active, sysdate)) and

Line 1196: FROM JTF_TASK_TEMP_GROUPS_VL

1192:
1193: CURSOR get_rec_from_value ( c_task_template_group JTF_TASK_TEMP_GROUPS_VL.template_group_name%TYPE )
1194: IS
1195: SELECT DISTINCT task_template_group_id
1196: FROM JTF_TASK_TEMP_GROUPS_VL
1197: WHERE trunc(sysdate) >= trunc(nvl(start_date_active, sysdate)) and
1198: trunc(sysdate) < trunc(nvl(end_date_active, sysdate+1)) and
1199: template_group_name = c_task_template_group;
1200:

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

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

Line 1204: FROM JTF_TASK_TEMP_GROUPS_VL

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