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.

[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on FND_GLOBAL

Line 248: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)

244: SELECT NULL
245: FROM jtf_state_responsibilities re
246: , jtf_state_rules_b ru
247: , jtf_state_transitions tr
248: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)
249: AND re.rule_id = ru.rule_id
250: AND ru.state_type = p_state_type
251: AND ru.rule_id = tr.rule_id
252: AND tr.initial_state_id = p_new_status_id;

Line 260: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)

256: SELECT NULL
257: FROM jtf_state_responsibilities re
258: , jtf_state_rules_b ru
259: , jtf_state_transitions tr
260: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)
261: AND re.rule_id = ru.rule_id
262: AND ru.state_type = p_state_type
263: AND ru.rule_id = tr.rule_id
264: AND tr.initial_state_id = p_old_status_id

Line 312: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)

308: FROM jtf_state_responsibilities re
309: , jtf_state_rules_b ru
310: , jtf_state_transitions tr
311: , jtf_task_statuses_tl ts
312: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)
313: AND re.rule_id = ru.rule_id
314: AND ru.state_type = p_state_type
315: AND ru.rule_id = tr.rule_id
316: AND ts.task_status_id = tr.initial_state_id

Line 326: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)

322: FROM jtf_state_responsibilities re
323: , jtf_state_rules_b ru
324: , jtf_state_transitions tr
325: , jtf_task_statuses_tl ts
326: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)
327: AND re.rule_id = ru.rule_id
328: AND ru.state_type = p_state_type
329: AND ru.rule_id = tr.rule_id
330: AND tr.initial_state_id = p_old_status_id

Line 336: l_return_value := l_return_value || fnd_global.local_chr(10) || v_valid_new_trans.name;

332: AND ts.language = userenv('LANG');
333: BEGIN
334: IF p_old_status_id IS NULL THEN
335: FOR v_valid_new_trans IN c_valid_new_trans LOOP
336: l_return_value := l_return_value || fnd_global.local_chr(10) || v_valid_new_trans.name;
337: END LOOP;
338: ELSE
339: FOR v_valid_existing_trans IN c_valid_existing_trans LOOP
340: l_return_value := l_return_value || fnd_global.local_chr(10) || v_valid_existing_trans.name;

Line 340: l_return_value := l_return_value || fnd_global.local_chr(10) || v_valid_existing_trans.name;

336: l_return_value := l_return_value || fnd_global.local_chr(10) || v_valid_new_trans.name;
337: END LOOP;
338: ELSE
339: FOR v_valid_existing_trans IN c_valid_existing_trans LOOP
340: l_return_value := l_return_value || fnd_global.local_chr(10) || v_valid_existing_trans.name;
341: END LOOP;
342: END IF;
343:
344: RETURN l_return_value;

Line 414: l_task_closure Varchar2(3) := fnd_profile.value_specific('CSF: Enforce_Task_Closure', fnd_global.user_id);

410: l_close_status_id NUMBER;
411: l_valid_statuses VARCHAR2 (2000);
412: l_valid_status BOOLEAN := FALSE;
413: l_update_schedulable_task VARCHAR2(3);
414: l_task_closure Varchar2(3) := fnd_profile.value_specific('CSF: Enforce_Task_Closure', fnd_global.user_id);
415: BEGIN
416: -- Initialize API return status to success
417: x_return_status := fnd_api.g_ret_sts_success;
418:

Line 1303: l_task_closure Varchar2(3) := fnd_profile.value_specific('CSF: Enforce_Task_Closure', fnd_global.user_id);

1299: AND ts.task_status_id = ta.assignment_status_id;
1300:
1301: l_task_status_id NUMBER;
1302: l_task_ovn NUMBER;
1303: l_task_closure Varchar2(3) := fnd_profile.value_specific('CSF: Enforce_Task_Closure', fnd_global.user_id);
1304: BEGIN
1305: x_return_status := fnd_api.g_ret_sts_success;
1306:
1307: IF p_new_sts_cancelled_flag = 'Y' THEN

Line 1954: l_overlap_tasks := l_overlap_tasks || fnd_global.local_chr(10) || v_overlap_tasks.overlap_task_num;

1950: END IF;
1951:
1952: IF fnd_api.to_boolean(p_find_overlap) THEN
1953: FOR v_overlap_tasks IN c_overlap_tasks(l_trip_id,l_new_start_date,l_new_end_date) LOOP
1954: l_overlap_tasks := l_overlap_tasks || fnd_global.local_chr(10) || v_overlap_tasks.overlap_task_num;
1955: END LOOP;
1956: END IF;
1957: END IF;
1958: END IF;