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.JTF_TASK_RESOURCES_PUB dependencies on DUAL

Line 109: FROM DUAL;

105: IF l_enabled_flag IN(jtf_task_utl.g_yes, jtf_task_utl.g_no) THEN
106: IF (p_task_template_id <> fnd_api.g_miss_num OR p_task_template_name <> fnd_api.g_miss_char) THEN
107: SELECT DECODE(p_task_template_id, fnd_api.g_miss_num, NULL, p_task_template_id)
108: INTO l_task_template_id
109: FROM DUAL;
110:
111: jtf_task_resources_pvt.validate_task_template(
112: x_return_status => l_return_status
113: , p_task_template_id => l_task_template_id

Line 131: FROM DUAL;

127: OR p_task_number <> fnd_api.g_miss_char
128: ) THEN
129: SELECT DECODE(p_task_id, fnd_api.g_miss_num, NULL, p_task_id)
130: INTO l_task_id
131: FROM DUAL;
132:
133: SELECT DECODE(p_task_number, fnd_api.g_miss_char, NULL, p_task_number)
134: INTO l_task_number
135: FROM DUAL;

Line 135: FROM DUAL;

131: FROM DUAL;
132:
133: SELECT DECODE(p_task_number, fnd_api.g_miss_char, NULL, p_task_number)
134: INTO l_task_number
135: FROM DUAL;
136:
137: jtf_task_utl.validate_task(
138: x_return_status => l_return_status
139: , p_task_id => l_task_id

Line 160: FROM DUAL;

156: END IF;
157: ELSIF(p_task_type_id <> fnd_api.g_miss_num OR p_task_type_name <> fnd_api.g_miss_char) THEN
158: SELECT DECODE(p_task_type_id, fnd_api.g_miss_num, NULL, p_task_type_id)
159: INTO l_task_type_id
160: FROM DUAL;
161:
162: SELECT DECODE(p_task_type_name, fnd_api.g_miss_char, NULL, p_task_type_name)
163: INTO l_task_type_name
164: FROM DUAL;

Line 164: FROM DUAL;

160: FROM DUAL;
161:
162: SELECT DECODE(p_task_type_name, fnd_api.g_miss_char, NULL, p_task_type_name)
163: INTO l_task_type_name
164: FROM DUAL;
165:
166: jtf_task_resources_pvt.validate_task_type(
167: x_return_status => l_return_status
168: , p_task_type_id => l_task_type_id

Line 431: FROM DUAL;

427: --- Validating for the task
428: IF NOT(p_task_id = fnd_api.g_miss_num AND p_task_number = fnd_api.g_miss_char) THEN
429: SELECT DECODE(p_task_id, fnd_api.g_miss_num, NULL, p_task_id)
430: INTO l_task_id
431: FROM DUAL;
432:
433: SELECT DECODE(p_task_number, fnd_api.g_miss_char, NULL, p_task_number)
434: INTO l_task_number
435: FROM DUAL;

Line 435: FROM DUAL;

431: FROM DUAL;
432:
433: SELECT DECODE(p_task_number, fnd_api.g_miss_char, NULL, p_task_number)
434: INTO l_task_number
435: FROM DUAL;
436:
437: IF (l_enabled_flag = fnd_api.g_true) THEN
438: ---- Here the task id is assigned null, if the task id is NOT input,
439: --- because then task number could be input.