DBA Data[Home] [Help]

APPS.CAC_SYNC_TASK_MAP_PKG dependencies on FND_GLOBAL

Line 33: l_user_id NUMBER := fnd_global.user_id;

29: p_principal_id IN NUMBER
30: )
31: IS
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,

Line 34: l_login_id NUMBER := fnd_global.login_id;

30: )
31: IS
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,

Line 68: l_user_id NUMBER := fnd_global.user_id;

64: p_principal_id IN NUMBER
65: )
66: IS
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,

Line 69: l_login_id NUMBER := fnd_global.login_id;

65: )
66: IS
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,