DBA Data[Home] [Help]

APPS.CAC_SYNC_TASK dependencies on JTA_SYNC_TASK_MAPPING

Line 437: SELECT jta_sync_task_mapping_s.nextval

433: BEGIN
434: FOR i IN 1 .. NVL (p_num_req, 0)
435: LOOP
436: -- Fix Bug# 2387015 to avoid using contacts sequence number
437: SELECT jta_sync_task_mapping_s.nextval
438: INTO x_results (i).syncid
439: FROM DUAL;
440: x_results (i).resultid := cac_sync_task_common.g_sync_success; --success, no message will be displayed to user
441: END LOOP;

Line 587: UPDATE jta_sync_task_mapping

583:
584: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'updating sync mapping after deletion and creation of data');
585: end if;
586:
587: UPDATE jta_sync_task_mapping
588: SET task_sync_id = l_old_sync_id,
589: last_update_date = sysdate,
590: last_updated_by = fnd_global.user_id,
591: last_update_login = fnd_global.login_id