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,
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,
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,
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;
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;
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,
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,
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;
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;
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;
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:
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');
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
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');
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