32: l_current_date DATE := SYSDATE;
33: l_user_id NUMBER := fnd_global.user_id;
34: l_login_id NUMBER := fnd_global.login_id;
35: BEGIN
36: INSERT INTO jta_sync_task_mapping
37: (task_sync_id,
38: task_id,
39: created_by,
40: creation_date,
67: l_current_date DATE := SYSDATE;
68: l_user_id NUMBER := fnd_global.user_id;
69: l_login_id NUMBER := fnd_global.login_id;
70: BEGIN
71: UPDATE jta_sync_task_mapping
72: SET resource_id = p_resource_id,
73: task_sync_id = p_task_sync_id,
74: task_id = p_task_id,
75: last_update_date = l_current_date,
84: )
85: IS
86: BEGIN
87: DELETE
88: FROM jta_sync_task_mapping
89: WHERE task_sync_id = p_task_sync_id;
90: END delete_row;
91: END cac_sync_task_map_pkg;