DBA Data[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on FND_GLOBAL

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

194: SELECT NULL
195: FROM jtf_state_responsibilities re
196: , jtf_state_rules_b ru
197: , jtf_state_transitions tr
198: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)
199: AND re.rule_id = ru.rule_id
200: AND ru.state_type = p_state_type
201: AND ru.rule_id = tr.rule_id
202: AND tr.initial_state_id = p_new_status_id;

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

206: SELECT NULL
207: FROM jtf_state_responsibilities re
208: , jtf_state_rules_b ru
209: , jtf_state_transitions tr
210: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)
211: AND re.rule_id = ru.rule_id
212: AND ru.state_type = p_state_type
213: AND ru.rule_id = tr.rule_id
214: AND tr.initial_state_id = p_old_status_id

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

258: FROM jtf_state_responsibilities re
259: , jtf_state_rules_b ru
260: , jtf_state_transitions tr
261: , jtf_task_statuses_tl ts
262: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)
263: AND re.rule_id = ru.rule_id
264: AND ru.state_type = p_state_type
265: AND ru.rule_id = tr.rule_id
266: AND ts.task_status_id = tr.initial_state_id

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

272: FROM jtf_state_responsibilities re
273: , jtf_state_rules_b ru
274: , jtf_state_transitions tr
275: , jtf_task_statuses_tl ts
276: WHERE (re.responsibility_id = fnd_global.resp_id OR fnd_global.resp_id = -1)
277: AND re.rule_id = ru.rule_id
278: AND ru.state_type = p_state_type
279: AND ru.rule_id = tr.rule_id
280: AND tr.initial_state_id = p_old_status_id

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

282: AND ts.language = userenv('LANG');
283: BEGIN
284: IF p_old_status_id IS NULL THEN
285: FOR v_valid_new_trans IN c_valid_new_trans LOOP
286: l_return_value := l_return_value || fnd_global.local_chr(10) || v_valid_new_trans.name;
287: END LOOP;
288: ELSE
289: FOR v_valid_existing_trans IN c_valid_existing_trans LOOP
290: l_return_value := l_return_value || fnd_global.local_chr(10) || v_valid_existing_trans.name;

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

286: l_return_value := l_return_value || fnd_global.local_chr(10) || v_valid_new_trans.name;
287: END LOOP;
288: ELSE
289: FOR v_valid_existing_trans IN c_valid_existing_trans LOOP
290: l_return_value := l_return_value || fnd_global.local_chr(10) || v_valid_existing_trans.name;
291: END LOOP;
292: END IF;
293:
294: RETURN l_return_value;

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

1713: END IF;
1714:
1715: IF fnd_api.to_boolean(p_find_overlap) THEN
1716: FOR v_overlap_tasks IN c_overlap_tasks(l_trip_id,l_new_start_date,l_new_end_date) LOOP
1717: l_overlap_tasks := l_overlap_tasks || fnd_global.local_chr(10) || v_overlap_tasks.overlap_task_num;
1718: END LOOP;
1719: END IF;
1720: END IF;
1721: END IF;