eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_CTX_SEARCH_PVT dependencies on PA_PROJECT_CTX_SEARCH

Line 1: PACKAGE BODY PA_PROJECT_CTX_SEARCH_PVT

1: PACKAGE BODY PA_PROJECT_CTX_SEARCH_PVT
2: -- $Header: PAXPCXVB.pls 120.2 2005/08/29 04:38:51 avaithia noship $
3: AS
4: PROCEDURE INSERT_ROW(p_project_id IN NUMBER,
5: p_template_flag IN VARCHAR2,

Line 15: l_ctx_description PA_PROJECT_CTX_SEARCH.ctx_description%TYPE;

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;
18:
19: -- We are not maintaining templates in PA_PROJECT_CTX_SEARCH table.

Line 19: -- We are not maintaining templates in PA_PROJECT_CTX_SEARCH table.

15: l_ctx_description PA_PROJECT_CTX_SEARCH.ctx_description%TYPE;
16: BEGIN
17: x_return_status := FND_API.G_RET_STS_SUCCESS;
18:
19: -- We are not maintaining templates in PA_PROJECT_CTX_SEARCH table.
20: IF p_template_flag = 'Y'
21: THEN
22: RETURN;
23: END IF;

Line 25: -- Check if record exists in PA_PROJECT_CTX_SEARCH for the p_project_Id

21: THEN
22: RETURN;
23: END IF;
24:
25: -- Check if record exists in PA_PROJECT_CTX_SEARCH for the p_project_Id
26: -- If it does, just return
27: l_exists := 'N';
28: BEGIN
29:

Line 31: FROM PA_PROJECT_CTX_SEARCH

27: l_exists := 'N';
28: BEGIN
29:
30: SELECT 'Y' into l_exists
31: FROM PA_PROJECT_CTX_SEARCH
32: WHERE project_id = p_project_id;
33:
34: EXCEPTION
35: WHEN NO_DATA_FOUND THEN

Line 63: PA_PROJECT_CTX_SEARCH_PKG.INSERT_ROW

59: IF l_project_description is not null THEN
60: l_ctx_description := l_ctx_description || ' ' || l_project_description;
61: END IF;
62:
63: PA_PROJECT_CTX_SEARCH_PKG.INSERT_ROW
64: (p_project_id => p_project_id,
65: p_ctx_description => l_ctx_description,
66: x_return_status => x_return_status);
67: END IF;

Line 73: ( p_pkg_name => 'PA_PROJECT_CTX_SEARCH_PVT'

69: EXCEPTION
70: WHEN OTHERS THEN
71: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
72: Fnd_Msg_Pub.add_exc_msg
73: ( p_pkg_name => 'PA_PROJECT_CTX_SEARCH_PVT'
74: , p_procedure_name => 'INSERT_ROW'
75: , p_error_text => SUBSTRB(SQLERRM,1,240));
76: -- Not included RAISE according to caller API reqmt.
77:

Line 91: l_ctx_description PA_PROJECT_CTX_SEARCH.ctx_description%TYPE;

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
94: x_return_status := FND_API.G_RET_STS_SUCCESS;
95:

Line 92: l_old_ctx_description PA_PROJECT_CTX_SEARCH.ctx_description%TYPE;

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
94: x_return_status := FND_API.G_RET_STS_SUCCESS;
95:
96: -- We are not maintaining templates in PA_PROJECT_CTX_SEARCH table.

Line 96: -- We are not maintaining templates in PA_PROJECT_CTX_SEARCH table.

92: l_old_ctx_description PA_PROJECT_CTX_SEARCH.ctx_description%TYPE;
93: BEGIN
94: x_return_status := FND_API.G_RET_STS_SUCCESS;
95:
96: -- We are not maintaining templates in PA_PROJECT_CTX_SEARCH table.
97: IF p_template_flag = 'Y'
98: THEN
99: RETURN;
100: END IF;

Line 107: FROM PA_PROJECT_CTX_SEARCH

103: l_exists := 'N';
104: BEGIN
105:
106: SELECT 'Y',ctx_description INTO l_exists,l_old_ctx_description
107: FROM PA_PROJECT_CTX_SEARCH
108: WHERE project_id = p_project_id;
109:
110: EXCEPTION
111: WHEN NO_DATA_FOUND THEN

Line 150: PA_PROJECT_CTX_SEARCH_PKG.UPDATE_ROW

146: -- Check if the CTX description has changed. If yes, update it.
147: IF l_old_ctx_description = l_ctx_description THEN
148: RETURN;
149: ELSE
150: PA_PROJECT_CTX_SEARCH_PKG.UPDATE_ROW
151: (p_project_id => p_project_id,
152: p_ctx_description => l_ctx_description,
153: x_return_status => x_return_status);
154: END IF;

Line 162: ( p_pkg_name => 'PA_PROJECT_CTX_SEARCH_PVT'

158: EXCEPTION
159: WHEN OTHERS THEN
160: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
161: Fnd_Msg_Pub.add_exc_msg
162: ( p_pkg_name => 'PA_PROJECT_CTX_SEARCH_PVT'
163: , p_procedure_name => 'UPDATE_ROW'
164: , p_error_text => SUBSTRB(SQLERRM,1,240));
165: -- Not included RAISE according to caller API reqmt.
166:

Line 176: -- We are not maintaining templates in PA_PROJECT_CTX_SEARCH table.

172: IS
173: BEGIN
174: x_return_status := FND_API.G_RET_STS_SUCCESS;
175:
176: -- We are not maintaining templates in PA_PROJECT_CTX_SEARCH table.
177: IF p_template_flag = 'Y'
178: THEN
179: RETURN;
180: END IF;

Line 182: PA_PROJECT_CTX_SEARCH_PKG.DELETE_ROW

178: THEN
179: RETURN;
180: END IF;
181:
182: PA_PROJECT_CTX_SEARCH_PKG.DELETE_ROW
183: (p_project_id => p_project_id,
184: x_return_status => x_return_status);
185: -- 4537865 : Included Exception Block
186: EXCEPTION

Line 190: ( p_pkg_name => 'PA_PROJECT_CTX_SEARCH_PVT'

186: EXCEPTION
187: WHEN OTHERS THEN
188: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
189: Fnd_Msg_Pub.add_exc_msg
190: ( p_pkg_name => 'PA_PROJECT_CTX_SEARCH_PVT'
191: , p_procedure_name => 'DELETE_ROW'
192: , p_error_text => SUBSTRB(SQLERRM,1,240));
193: -- Not included RAISE according to caller API reqmt.
194: END DELETE_ROW;

Line 196: END PA_PROJECT_CTX_SEARCH_PVT;

192: , p_error_text => SUBSTRB(SQLERRM,1,240));
193: -- Not included RAISE according to caller API reqmt.
194: END DELETE_ROW;
195:
196: END PA_PROJECT_CTX_SEARCH_PVT;