APPS.JTF_TASK_SYNC_UPGRADE_PKG dependencies on FND_GLOBAL

Line 156: , last_updated_by = fnd_global.user_id

152:
153: -- Nullify recurrence_rule_id
154: UPDATE jtf_tasks_b
155: SET recurrence_rule_id = NULL
156: , last_updated_by = fnd_global.user_id
157: WHERE task_id = rec_duplicates.task_id;
158:
159: COMMIT;
160:

Line 221: , last_updated_by = fnd_global.user_id

217: THEN
218: -- Nullify recurrence_rule_id
219: UPDATE jtf_tasks_b
220: SET recurrence_rule_id = NULL
221: , last_updated_by = fnd_global.user_id
222: WHERE task_id = rec_repeat_appt.task_id;
223:
224: l_num := l_num + 1;
225:

Line 309: , last_updated_by = fnd_global.user_id

305: FOR rec_tasks IN c_tasks
306: LOOP
307: UPDATE jtf_tasks_b
308: SET object_changed_date = TO_DATE('01/02/1970', 'MM/DD/YYYY')
309: , last_updated_by = fnd_global.user_id
310: WHERE rowid = rec_tasks.row_id;
311:
312: l_num := l_num + 1;
313:

Line 519: , last_updated_by = fnd_global.user_id

515: IF NVL(rec_updated_appts.deleted_flag,'N') = 'N'
516: THEN
517: UPDATE jtf_tasks_b
518: SET recurrence_rule_id = NULL
519: , last_updated_by = fnd_global.user_id
520: WHERE task_id = rec_updated_appts.task_id;
521:
522: l_updated := TRUE;
523: END IF;

Line 620: , last_updated_by = fnd_global.user_id

616:
617: UPDATE jtf_task_recur_rules
618: SET occurs_number = l_occurs_number
619: , end_date_active = l_max_date
620: , last_updated_by = fnd_global.user_id
621: WHERE recurrence_rule_id = rec_recur.recurrence_rule_id;
622:
623: l_num := l_num + 1;
624:

Line 690: , last_updated_by = fnd_global.user_id

686: l_num := l_num + 1;
687:
688: UPDATE jtf_task_all_assignments
689: SET assignment_status_id = 18
690: , last_updated_by = fnd_global.user_id
691: WHERE task_assignment_id = rec_appt_with_mixed_status.task_assignment_id;
692:
693: IF (l_num - l_commit_records) = l_commit_checkpoint
694: THEN

Line 784: , last_updated_by = fnd_global.user_id

780: l_num := l_num + 1;
781:
782: UPDATE jtf_tasks_b
783: SET recurrence_rule_id = NULL
784: , last_updated_by = fnd_global.user_id
785: WHERE recurrence_rule_id = rec_recur.recurrence_rule_id
786: AND NVL(deleted_flag,'N') <> 'Y';
787:
788: IF (l_num - l_commit_records) = l_commit_checkpoint