DBA Data[Home] [Help]

APPS.PA_TASKS_MAINT_PVT dependencies on FND_GLOBAL

Line 1668: FND_GLOBAL.USER_ID, -- created_by

1664: l_new_task_id,
1665: p_project_id,
1666: p_task_number,
1667: sysdate,
1668: FND_GLOBAL.USER_ID, -- created_by
1669: sysdate,
1670: FND_GLOBAL.USER_ID, -- Last_Updated_By
1671: FND_GLOBAL.USER_ID, -- Last_Update_Login
1672: p_task_name,

Line 1670: FND_GLOBAL.USER_ID, -- Last_Updated_By

1666: p_task_number,
1667: sysdate,
1668: FND_GLOBAL.USER_ID, -- created_by
1669: sysdate,
1670: FND_GLOBAL.USER_ID, -- Last_Updated_By
1671: FND_GLOBAL.USER_ID, -- Last_Update_Login
1672: p_task_name,
1673: p_long_task_name,
1674: l_top_task_id,

Line 1671: FND_GLOBAL.USER_ID, -- Last_Update_Login

1667: sysdate,
1668: FND_GLOBAL.USER_ID, -- created_by
1669: sysdate,
1670: FND_GLOBAL.USER_ID, -- Last_Updated_By
1671: FND_GLOBAL.USER_ID, -- Last_Update_Login
1672: p_task_name,
1673: p_long_task_name,
1674: l_top_task_id,
1675: TWBS_LEVEL,

Line 1788: last_updated_by = FND_GLOBAL.USER_ID,

1784: SET
1785: CHARGEABLE_FLAG = 'N',
1786: RECEIVE_PROJECT_INVOICE_FLAG = 'N',
1787: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0)+1,
1788: last_updated_by = FND_GLOBAL.USER_ID,
1789: last_update_login = FND_GLOBAL.USER_ID,
1790: last_update_date = sysdate
1791: WHERE TASK_ID = l_parent_task_Id;
1792: END IF;

Line 1789: last_update_login = FND_GLOBAL.USER_ID,

1785: CHARGEABLE_FLAG = 'N',
1786: RECEIVE_PROJECT_INVOICE_FLAG = 'N',
1787: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0)+1,
1788: last_updated_by = FND_GLOBAL.USER_ID,
1789: last_update_login = FND_GLOBAL.USER_ID,
1790: last_update_date = sysdate
1791: WHERE TASK_ID = l_parent_task_Id;
1792: END IF;
1793: END IF;

Line 3209: FND_GLOBAL.USER_ID,

3205: p_task_id,
3206: p_project_id,
3207: TTASK_NUMBER,
3208: sysdate,
3209: FND_GLOBAL.USER_ID,
3210: FND_GLOBAL.USER_ID,
3211: TTASK_NAME,
3212: TLONG_TASK_NAME, --new
3213: TTOP_TASK_ID,

Line 3210: FND_GLOBAL.USER_ID,

3206: p_project_id,
3207: TTASK_NUMBER,
3208: sysdate,
3209: FND_GLOBAL.USER_ID,
3210: FND_GLOBAL.USER_ID,
3211: TTASK_NAME,
3212: TLONG_TASK_NAME, --new
3213: TTOP_TASK_ID,
3214: TWBS_LEVEL,

Line 3497: last_updated_by = FND_GLOBAL.USER_ID,

3493: IF (Pa_Task_Utils.check_child_Exists(NVL(t_parent_task_id,0)) = 0 ) THEN
3494: UPDATE Pa_tasks
3495: SET Chargeable_Flag = 'Y',
3496: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0) + 1,
3497: last_updated_by = FND_GLOBAL.USER_ID,
3498: last_update_login = FND_GLOBAL.USER_ID,
3499: last_update_date = sysdate
3500: WHERE TASK_ID = t_parent_task_id;
3501: END IF;

Line 3498: last_update_login = FND_GLOBAL.USER_ID,

3494: UPDATE Pa_tasks
3495: SET Chargeable_Flag = 'Y',
3496: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0) + 1,
3497: last_updated_by = FND_GLOBAL.USER_ID,
3498: last_update_login = FND_GLOBAL.USER_ID,
3499: last_update_date = sysdate
3500: WHERE TASK_ID = t_parent_task_id;
3501: END IF;
3502: END IF;

Line 5964: last_updated_by = FND_GLOBAL.USER_ID,

5960: IF (Pa_Task_Utils.check_child_Exists(NVL(p_reference_task_id,0)) = 1 ) THEN
5961: UPDATE Pa_tasks
5962: SET Chargeable_Flag = 'N',
5963: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0) + 1,
5964: last_updated_by = FND_GLOBAL.USER_ID,
5965: last_update_login = FND_GLOBAL.USER_ID,
5966: last_update_date = sysdate
5967: WHERE TASK_ID = p_reference_task_id;
5968: END IF;

Line 5965: last_update_login = FND_GLOBAL.USER_ID,

5961: UPDATE Pa_tasks
5962: SET Chargeable_Flag = 'N',
5963: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0) + 1,
5964: last_updated_by = FND_GLOBAL.USER_ID,
5965: last_update_login = FND_GLOBAL.USER_ID,
5966: last_update_date = sysdate
5967: WHERE TASK_ID = p_reference_task_id;
5968: END IF;
5969:

Line 6118: l_user_id := fnd_global.user_id;

6114: x_return_status := FND_API.G_RET_STS_SUCCESS;
6115:
6116: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6117: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6118: l_user_id := fnd_global.user_id;
6119: l_login_id := fnd_global.login_id;
6120: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6121:
6122: --l_debug_mode := NVL(p_debug_mode,'N');

Line 6119: l_login_id := fnd_global.login_id;

6115:
6116: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6117: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6118: l_user_id := fnd_global.user_id;
6119: l_login_id := fnd_global.login_id;
6120: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6121:
6122: --l_debug_mode := NVL(p_debug_mode,'N');
6123: IF l_debug_mode = 'Y' THEN

Line 6486: l_user_id := fnd_global.user_id;

6482: x_return_status := FND_API.G_RET_STS_SUCCESS;
6483:
6484: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6485: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6486: l_user_id := fnd_global.user_id;
6487: l_login_id := fnd_global.login_id;
6488: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6489:
6490: --l_debug_mode := NVL(p_debug_mode,'N');

Line 6487: l_login_id := fnd_global.login_id;

6483:
6484: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6485: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6486: l_user_id := fnd_global.user_id;
6487: l_login_id := fnd_global.login_id;
6488: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6489:
6490: --l_debug_mode := NVL(p_debug_mode,'N');
6491: IF l_debug_mode = 'Y' THEN