APPS.PA_PROJECT_CTX_SEARCH_PVT dependencies on PA_PROJECTS_ALL

Line 12: l_project_long_name PA_PROJECTS_ALL.long_name%TYPE;

8: p_project_long_name IN VARCHAR2 default null,
9: p_project_description IN VARCHAR2 default null,
10: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
11: IS
12: l_project_long_name PA_PROJECTS_ALL.long_name%TYPE;
13: l_project_description PA_PROJECTS_ALL.description%TYPE;
14: l_exists VARCHAR2(1);
15: l_ctx_description PA_PROJECT_CTX_SEARCH.ctx_description%TYPE;
16: BEGIN

Line 13: l_project_description PA_PROJECTS_ALL.description%TYPE;

9: p_project_description IN VARCHAR2 default null,
10: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
11: IS
12: l_project_long_name PA_PROJECTS_ALL.long_name%TYPE;
13: l_project_description PA_PROJECTS_ALL.description%TYPE;
14: l_exists VARCHAR2(1);
15: l_ctx_description PA_PROJECT_CTX_SEARCH.ctx_description%TYPE;
16: BEGIN
17: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 88: l_project_long_name PA_PROJECTS_ALL.long_name%TYPE;

84: p_project_long_name IN VARCHAR2 default null,
85: p_project_description IN VARCHAR2 default null,
86: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
87: IS
88: l_project_long_name PA_PROJECTS_ALL.long_name%TYPE;
89: l_project_description PA_PROJECTS_ALL.description%TYPE;
90: l_exists VARCHAR2(1);
91: l_ctx_description PA_PROJECT_CTX_SEARCH.ctx_description%TYPE;
92: l_old_ctx_description PA_PROJECT_CTX_SEARCH.ctx_description%TYPE;

Line 89: l_project_description PA_PROJECTS_ALL.description%TYPE;

85: p_project_description IN VARCHAR2 default null,
86: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
87: IS
88: l_project_long_name PA_PROJECTS_ALL.long_name%TYPE;
89: l_project_description PA_PROJECTS_ALL.description%TYPE;
90: l_exists VARCHAR2(1);
91: l_ctx_description PA_PROJECT_CTX_SEARCH.ctx_description%TYPE;
92: l_old_ctx_description PA_PROJECT_CTX_SEARCH.ctx_description%TYPE;
93: BEGIN