DBA Data[Home] [Help]

APPS.PA_TASKS_MAINT_PVT dependencies on FND_GLOBAL

Line 1683: FND_GLOBAL.USER_ID, -- created_by

1679: l_new_task_id,
1680: p_project_id,
1681: p_task_number,
1682: sysdate,
1683: FND_GLOBAL.USER_ID, -- created_by
1684: sysdate,
1685: FND_GLOBAL.USER_ID, -- Last_Updated_By
1686: FND_GLOBAL.USER_ID, -- Last_Update_Login
1687: p_task_name,

Line 1685: FND_GLOBAL.USER_ID, -- Last_Updated_By

1681: p_task_number,
1682: sysdate,
1683: FND_GLOBAL.USER_ID, -- created_by
1684: sysdate,
1685: FND_GLOBAL.USER_ID, -- Last_Updated_By
1686: FND_GLOBAL.USER_ID, -- Last_Update_Login
1687: p_task_name,
1688: p_long_task_name,
1689: l_top_task_id,

Line 1686: FND_GLOBAL.USER_ID, -- Last_Update_Login

1682: sysdate,
1683: FND_GLOBAL.USER_ID, -- created_by
1684: sysdate,
1685: FND_GLOBAL.USER_ID, -- Last_Updated_By
1686: FND_GLOBAL.USER_ID, -- Last_Update_Login
1687: p_task_name,
1688: p_long_task_name,
1689: l_top_task_id,
1690: TWBS_LEVEL,

Line 1804: last_updated_by = FND_GLOBAL.USER_ID,

1800: SET
1801: CHARGEABLE_FLAG = 'N',
1802: RECEIVE_PROJECT_INVOICE_FLAG = 'N',
1803: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0)+1,
1804: last_updated_by = FND_GLOBAL.USER_ID,
1805: last_update_login = FND_GLOBAL.USER_ID,
1806: last_update_date = sysdate
1807: WHERE TASK_ID = l_parent_task_Id;
1808: END IF;

Line 1805: last_update_login = FND_GLOBAL.USER_ID,

1801: CHARGEABLE_FLAG = 'N',
1802: RECEIVE_PROJECT_INVOICE_FLAG = 'N',
1803: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0)+1,
1804: last_updated_by = FND_GLOBAL.USER_ID,
1805: last_update_login = FND_GLOBAL.USER_ID,
1806: last_update_date = sysdate
1807: WHERE TASK_ID = l_parent_task_Id;
1808: END IF;
1809: END IF;

Line 3227: FND_GLOBAL.USER_ID,

3223: p_task_id,
3224: p_project_id,
3225: TTASK_NUMBER,
3226: sysdate,
3227: FND_GLOBAL.USER_ID,
3228: FND_GLOBAL.USER_ID,
3229: TTASK_NAME,
3230: TLONG_TASK_NAME, --new
3231: TTOP_TASK_ID,

Line 3228: FND_GLOBAL.USER_ID,

3224: p_project_id,
3225: TTASK_NUMBER,
3226: sysdate,
3227: FND_GLOBAL.USER_ID,
3228: FND_GLOBAL.USER_ID,
3229: TTASK_NAME,
3230: TLONG_TASK_NAME, --new
3231: TTOP_TASK_ID,
3232: TWBS_LEVEL,

Line 3515: last_updated_by = FND_GLOBAL.USER_ID,

3511: IF (Pa_Task_Utils.check_child_Exists(NVL(t_parent_task_id,0)) = 0 ) THEN
3512: UPDATE Pa_tasks
3513: SET Chargeable_Flag = 'Y',
3514: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0) + 1,
3515: last_updated_by = FND_GLOBAL.USER_ID,
3516: last_update_login = FND_GLOBAL.USER_ID,
3517: last_update_date = sysdate
3518: WHERE TASK_ID = t_parent_task_id;
3519: END IF;

Line 3516: last_update_login = FND_GLOBAL.USER_ID,

3512: UPDATE Pa_tasks
3513: SET Chargeable_Flag = 'Y',
3514: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0) + 1,
3515: last_updated_by = FND_GLOBAL.USER_ID,
3516: last_update_login = FND_GLOBAL.USER_ID,
3517: last_update_date = sysdate
3518: WHERE TASK_ID = t_parent_task_id;
3519: END IF;
3520: END IF;

Line 6014: last_updated_by = FND_GLOBAL.USER_ID,

6010: IF (Pa_Task_Utils.check_child_Exists(NVL(p_reference_task_id,0)) = 1 ) THEN
6011: UPDATE Pa_tasks
6012: SET Chargeable_Flag = 'N',
6013: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0) + 1,
6014: last_updated_by = FND_GLOBAL.USER_ID,
6015: last_update_login = FND_GLOBAL.USER_ID,
6016: last_update_date = sysdate
6017: WHERE TASK_ID = p_reference_task_id;
6018: END IF;

Line 6015: last_update_login = FND_GLOBAL.USER_ID,

6011: UPDATE Pa_tasks
6012: SET Chargeable_Flag = 'N',
6013: RECORD_VERSION_NUMBER = nvl(RECORD_VERSION_NUMBER,0) + 1,
6014: last_updated_by = FND_GLOBAL.USER_ID,
6015: last_update_login = FND_GLOBAL.USER_ID,
6016: last_update_date = sysdate
6017: WHERE TASK_ID = p_reference_task_id;
6018: END IF;
6019:

Line 6186: l_user_id := fnd_global.user_id;

6182: x_return_status := FND_API.G_RET_STS_SUCCESS;
6183:
6184: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6185: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6186: l_user_id := fnd_global.user_id;
6187: l_login_id := fnd_global.login_id;
6188: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6189:
6190: --l_debug_mode := NVL(p_debug_mode,'N');

Line 6187: l_login_id := fnd_global.login_id;

6183:
6184: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6185: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6186: l_user_id := fnd_global.user_id;
6187: l_login_id := fnd_global.login_id;
6188: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6189:
6190: --l_debug_mode := NVL(p_debug_mode,'N');
6191: IF l_debug_mode = 'Y' THEN

Line 6585: l_user_id := fnd_global.user_id;

6581: x_return_status := FND_API.G_RET_STS_SUCCESS;
6582:
6583: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6584: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6585: l_user_id := fnd_global.user_id;
6586: l_login_id := fnd_global.login_id;
6587: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6588:
6589: --l_debug_mode := NVL(p_debug_mode,'N');

Line 6586: l_login_id := fnd_global.login_id;

6582:
6583: --Bug 3735089 - instead of fnd_profile.value use fnd_profile.value_specific
6584: --l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6585: l_user_id := fnd_global.user_id;
6586: l_login_id := fnd_global.login_id;
6587: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',l_user_id, l_login_id,275,null,null),'N');
6588:
6589: --l_debug_mode := NVL(p_debug_mode,'N');
6590: IF l_debug_mode = 'Y' THEN