28: p_resource_id IN NUMBER
29: )
30: IS
31: l_current_date DATE := SYSDATE;
32: l_user_id NUMBER := fnd_global.user_id;
33: l_login_id NUMBER := fnd_global.login_id;
34: BEGIN
35: INSERT INTO jta_sync_task_mapping
36: (task_sync_id,
29: )
30: IS
31: l_current_date DATE := SYSDATE;
32: l_user_id NUMBER := fnd_global.user_id;
33: l_login_id NUMBER := fnd_global.login_id;
34: BEGIN
35: INSERT INTO jta_sync_task_mapping
36: (task_sync_id,
37: task_id,
60: p_resource_id IN NUMBER
61: )
62: IS
63: l_current_date DATE := SYSDATE;
64: l_user_id NUMBER := fnd_global.user_id;
65: l_login_id NUMBER := fnd_global.login_id;
66: BEGIN
67: UPDATE jta_sync_task_mapping
68: SET resource_id = p_resource_id,
61: )
62: IS
63: l_current_date DATE := SYSDATE;
64: l_user_id NUMBER := fnd_global.user_id;
65: l_login_id NUMBER := fnd_global.login_id;
66: BEGIN
67: UPDATE jta_sync_task_mapping
68: SET resource_id = p_resource_id,
69: task_sync_id = p_task_sync_id,