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_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.5.12020000.2 2012/07/19 09:30:33 admarath 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 222: FROM pa_ci_impacts sourceImpacts,

218: -- Bug 9693010: to populate the source impacts for target
219: CURSOR get_impact_info
220: IS
221: SELECT sourceImpacts.*
222: FROM pa_ci_impacts sourceImpacts,
223: pa_control_items sourceCi,
224: pa_control_items targetCi
225: WHERE sourceImpacts.ci_id = p_source_ci_id
226: and sourceImpacts.impact_type_code in ('FINPLAN', 'FINPLAN_REVENUE')

Line 236: FROM pa_ci_impacts

232: CURSOR get_orig_info
233: is
234: SELECT ci_impact_id, description, implementation_comment,
235: implementation_date, implemented_by, record_version_number, impacted_task_id
236: FROM pa_ci_impacts
237: WHERE ci_id = p_dest_ci_id
238: AND impact_type_code = l_impact_type_code;
239:
240: CURSOR is_ok_to_copy

Line 245: select ci_impact_id from pa_ci_impacts pci

241: IS
242: select 'N' from dual
243: where exists
244: (
245: select ci_impact_id from pa_ci_impacts pci
246: where pci.ci_id = p_source_ci_id
247: and pci.impact_type_code <> 'FINPLAN' /* Bug 3724520 */
248: and pci.impact_type_code <> 'SUPPLIER'
249: and not exists

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

278: l_ret VARCHAR2(1) := 'Y';
279:
280: BEGIN
281: -- Initialize the Error Stack
282: PA_DEBUG.init_err_stack('Pa_ci_impacts_util.copy_impact');
283:
284: -- Initialize the return status to success
285: x_return_status := FND_API.G_RET_STS_SUCCESS;
286:

Line 341: pa_ci_impacts_pkg.insert_row(

337: l_implementation_date, l_implemented_by, l_record_ver_number, l_task_id;
338:
339: IF get_orig_info%notfound THEN
340: -- insert a new record to the new impact
341: pa_ci_impacts_pkg.insert_row(
342: l_rowid,
343: l_new_ci_impact_id,
344: p_dest_ci_id,
345: rec.impact_type_code,

Line 362: pa_ci_impacts_pkg.update_row(

358: ELSE
359: l_temp2 := Substr(l_desp || ' ' || rec.description, 1, 4000);
360:
361: -- update the existing one
362: pa_ci_impacts_pkg.update_row(
363: l_ci_impact_id,
364: p_dest_ci_id,
365: l_impact_type_code,
366: NULL,

Line 393: pa_ci_impacts_pkg.insert_row(

389: l_implementation_date, l_implemented_by, l_record_ver_number, l_task_id;
390:
391: IF get_orig_info%notfound THEN
392: -- insert a new record to the new impact
393: pa_ci_impacts_pkg.insert_row(
394: l_rowid,
395: l_new_ci_impact_id,
396: p_dest_ci_id,
397: rec.impact_type_code,

Line 414: pa_ci_impacts_pkg.update_row(

410: ELSE
411: l_temp2 := Substr(l_desp || ' ' || rec.description, 1, 4000);
412:
413: -- update the existing one
414: pa_ci_impacts_pkg.update_row(
415: l_ci_impact_id,
416: p_dest_ci_id,
417: l_impact_type_code,
418: NULL,

Line 502: From pa_ci_impacts

498: IS
499: CURSOR get_type_code
500: IS
501: select impact_type_code,ci_id
502: From pa_ci_impacts
503: WHERE ci_impact_id = p_ci_impact_id;
504:
505: l_temp VARCHAR2(30);
506: l_ciid NUMBER;

Line 825: END Pa_ci_impacts_util;

821: RETURN 'NONE';
822:
823: END get_implement_impact_mode;
824:
825: END Pa_ci_impacts_util;