26: null,
27: null,
28: null,
29: null,
30: fnd_global.user_id,
31: sysdate,
32: fnd_global.user_id,
33: sysdate,
34: fnd_global.login_id);
28: null,
29: null,
30: fnd_global.user_id,
31: sysdate,
32: fnd_global.user_id,
33: sysdate,
34: fnd_global.login_id);
35:
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
30: fnd_global.user_id,
31: sysdate,
32: fnd_global.user_id,
33: sysdate,
34: fnd_global.login_id);
35:
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37:
38: EXCEPTION
54:
55: UPDATE PA_PROJECT_CTX_SEARCH
56: SET CTX_DESCRIPTION = p_ctx_description,
57: LAST_UPDATE_DATE = sysdate,
58: LAST_UPDATED_BY = fnd_global.user_id,
59: LAST_UPDATE_LOGIN = fnd_global.login_id
60: WHERE project_id = p_project_id;
61:
62: x_return_status := FND_API.G_RET_STS_SUCCESS;
55: UPDATE PA_PROJECT_CTX_SEARCH
56: SET CTX_DESCRIPTION = p_ctx_description,
57: LAST_UPDATE_DATE = sysdate,
58: LAST_UPDATED_BY = fnd_global.user_id,
59: LAST_UPDATE_LOGIN = fnd_global.login_id
60: WHERE project_id = p_project_id;
61:
62: x_return_status := FND_API.G_RET_STS_SUCCESS;
63: