APPS.PA_CI_IMPACTS_UTIL dependencies on PA_CI_IMPACTS

Line 1: PACKAGE BODY Pa_ci_impacts_util AS

1: PACKAGE BODY Pa_ci_impacts_util AS
2: /* $Header: PACIIPUB.pls 120.1 2007/09/30 15:58:06 kkorada ship $ */
3:
4: function is_any_impact_implemented (
5: p_ci_id IN NUMBER := null

Line 16: FROM pa_ci_impacts

12: SELECT 'X'
13: INTO l_temp from dual
14: WHERE exists(
15: SELECT ci_impact_id
16: FROM pa_ci_impacts
17: WHERE ci_id = p_ci_id
18: AND (implementation_date IS NOT NULL
19: OR implemented_by IS NOT NULL));
20:

Line 65: FROM pa_ci_impacts

61: SELECT 'X'
62: INTO l_temp from dual
63: WHERE exists(
64: SELECT ci_impact_id
65: FROM pa_ci_impacts
66: WHERE ci_id = p_ci_id
67: AND (implementation_date IS NOT NULL
68: OR implemented_by IS NOT NULL)
69: AND impact_type_code = p_impact_type_code);

Line 91: FROM pa_ci_impacts

87: SELECT 'X'
88: INTO l_temp from dual
89: WHERE exists(
90: SELECT ci_impact_id
91: FROM pa_ci_impacts
92: WHERE ci_id = p_ci_id
93: AND impact_type_code = p_impact_type_code);
94:
95: RETURN TRUE;

Line 114: FROM pa_ci_impacts

110: SELECT 'X'
111: INTO l_temp from dual
112: WHERE exists(
113: SELECT ci_impact_id
114: FROM pa_ci_impacts
115: WHERE ci_id = p_ci_id
116: AND (implementation_date IS NULL
117: OR implemented_by IS NULL)
118: AND impact_type_code <> 'FINPLAN' /* Bug 4153868 */

Line 146: PA_DEBUG.init_err_stack('Pa_ci_impacts_util.delete_all_impacts');

142: )
143: IS
144: BEGIN
145: -- Initialize the Error Stack
146: PA_DEBUG.init_err_stack('Pa_ci_impacts_util.delete_all_impacts');
147:
148: -- Initialize the return status to success
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150:

Line 157: DELETE FROM pa_ci_impacts

153: FND_MSG_PUB.initialize;
154: END IF;
155:
156: IF (p_validate_only = 'F') THEN
157: DELETE FROM pa_ci_impacts
158: WHERE ci_id = p_ci_id;
159: END IF;
160:
161: -- Commit if the flag is set and there is no error

Line 209: FROM pa_ci_impacts sourceImpacts,

205: -- the impact to be created
206: CURSOR get_include_impact_info
207: IS
208: SELECT sourceImpacts.*
209: FROM pa_ci_impacts sourceImpacts,
210: pa_control_items targetCi,
211: pa_ci_impact_type_usage targetUsage
212: WHERE sourceImpacts.ci_id = p_source_ci_id
213: AND sourceImpacts.impact_type_code NOT IN ('FINPLAN_COST','FINPLAN_REVENUE','FINPLAN')

Line 223: FROM pa_ci_impacts

219: CURSOR get_orig_info
220: is
221: SELECT ci_impact_id, description, implementation_comment,
222: implementation_date, implemented_by, record_version_number, impacted_task_id
223: FROM pa_ci_impacts
224: WHERE ci_id = p_dest_ci_id
225: AND impact_type_code = l_impact_type_code;
226:
227: CURSOR is_ok_to_copy

Line 232: select ci_impact_id from pa_ci_impacts pci

228: IS
229: select 'N' from dual
230: where exists
231: (
232: select ci_impact_id from pa_ci_impacts pci
233: where pci.ci_id = p_source_ci_id
234: and pci.impact_type_code <> 'FINPLAN' /* Bug 3724520 */
235: and not exists
236: (

Line 268: PA_DEBUG.init_err_stack('Pa_ci_impacts_util.copy_impact');

264: l_ret VARCHAR2(1) := 'Y';
265:
266: BEGIN
267: -- Initialize the Error Stack
268: PA_DEBUG.init_err_stack('Pa_ci_impacts_util.copy_impact');
269:
270: -- Initialize the return status to success
271: x_return_status := FND_API.G_RET_STS_SUCCESS;
272:

Line 309: pa_ci_impacts_pkg.insert_row(

305: l_implementation_date, l_implemented_by, l_record_ver_number, l_task_id;
306:
307: IF get_orig_info%notfound THEN
308: -- insert a new record to the new impact
309: pa_ci_impacts_pkg.insert_row(
310: l_rowid,
311: l_new_ci_impact_id,
312: p_dest_ci_id,
313: rec.impact_type_code,

Line 330: pa_ci_impacts_pkg.update_row(

326: ELSE
327: l_temp2 := Substr(l_desp || ' ' || rec.description, 1, 4000);
328:
329: -- update the existing one
330: pa_ci_impacts_pkg.update_row(
331: l_ci_impact_id,
332: p_dest_ci_id,
333: l_impact_type_code,
334: NULL,

Line 429: From pa_ci_impacts

425: IS
426: CURSOR get_type_code
427: IS
428: select impact_type_code,ci_id
429: From pa_ci_impacts
430: WHERE ci_impact_id = p_ci_impact_id;
431:
432: l_temp VARCHAR2(30);
433: l_ciid NUMBER;

Line 752: END Pa_ci_impacts_util;

748: RETURN 'NONE';
749:
750: END get_implement_impact_mode;
751:
752: END Pa_ci_impacts_util;