APPS.PA_CI_IMPACTS_PVT dependencies on PA_CI_IMPACTS

Line 1: PACKAGE BODY PA_CI_IMPACTS_pvt AS

1: PACKAGE BODY PA_CI_IMPACTS_pvt AS
2: /* $Header: PACIIPVB.pls 120.1 2005/08/02 03:58:29 raluthra noship $ */
3:
4: PROCEDURE create_ci_impact (
5: p_api_version IN NUMBER := 1.0,

Line 33: pa_ci_impacts

29:
30: CURSOR check_exists is
31: SELECT 'Y' FROM dual
32: WHERE exists (SELECT ci_impact_id FROM
33: pa_ci_impacts
34: WHERE
35: ci_id = p_ci_id
36: AND impact_type_code = p_impact_type_code);
37:

Line 41: pa_debug.set_err_stack ('PA_CI_IMPACTS_PVT.CREATE_CI_IMPACTS');

37:
38: l_dummy VARCHAR2(1);
39:
40: BEGIN
41: pa_debug.set_err_stack ('PA_CI_IMPACTS_PVT.CREATE_CI_IMPACTS');
42:
43: IF p_commit = 'T' THEN
44: SAVEPOINT create_ci_impact;
45: END IF;

Line 68: PA_CI_IMPACTS_pkg.insert_row(

64: END IF;
65: CLOSE check_exists;
66:
67: IF (p_validate_only <> 'T' AND x_return_status = 'S') THEN
68: PA_CI_IMPACTS_pkg.insert_row(
69: x_rowid => l_rowid,
70: x_ci_impact_id => x_ci_impact_id,
71: x_ci_id => p_ci_id,
72: x_impact_type_code => p_impact_type_code,

Line 106: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACTS_PVT',

102: ROLLBACK TO create_ci_impact;
103: END IF;
104:
105: x_return_status := 'U';
106: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACTS_PVT',
107: p_procedure_name => 'CREATE_CI_IMPACT',
108: p_error_text => SUBSTRB(SQLERRM,1,240));
109:
110: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 130: pa_debug.set_err_stack ('PA_CI_IMPACTS_PVT.DELETE_CI_IMPACT');

126: )
127: IS
128: l_temp VARCHAR2(1);
129: BEGIN
130: pa_debug.set_err_stack ('PA_CI_IMPACTS_PVT.DELETE_CI_IMPACT');
131:
132: IF p_commit = 'T' THEN
133: SAVEPOINT delete_ci_impact;
134: END IF;

Line 145: pa_ci_impacts_util.is_delete_impact_ok

141: x_msg_count := 0;
142: x_msg_data := '';
143:
144: -- check if it is OK to delete
145: pa_ci_impacts_util.is_delete_impact_ok
146: (
147: p_ci_impact_id,
148: x_return_status ,
149: x_msg_count ,

Line 155: /* PA_CI_IMPACTS_pkg.lock_row (

151: );
152:
153: IF x_return_status = 'S' then
154: -- Trying to lock the record
155: /* PA_CI_IMPACTS_pkg.lock_row (
156: x_ci_impact_id => p_ci_impact_id,
157: x_impact_type_code => p_impact_type_code,
158: x_record_version_number => p_record_version_number,
159: x_ci_id => p_ci_id);*/

Line 162: PA_CI_IMPACTS_pkg.delete_row(

158: x_record_version_number => p_record_version_number,
159: x_ci_id => p_ci_id);*/
160:
161: IF (p_validate_only <> 'T' AND x_return_status = 'S') THEN
162: PA_CI_IMPACTS_pkg.delete_row(
163: x_ci_impact_id => p_ci_impact_id,
164: x_record_version_number => p_record_version_number
165: );
166: END IF;

Line 259: pa_debug.set_err_stack ('PA_CI_IMPACTS_PVT.UPDATE_CI_IMPACTS');

255: WHERE p_impact_type_code = pl.lookup_code
256: and pl.lookup_type = 'PA_CI_IMPACT_TYPES';
257:
258: BEGIN
259: pa_debug.set_err_stack ('PA_CI_IMPACTS_PVT.UPDATE_CI_IMPACTS');
260:
261: IF p_commit = 'T' THEN
262: SAVEPOINT update_ci_impact;
263: END IF;

Line 343: PA_CI_IMPACTS_pkg.update_row(

339: END IF;
340:
341:
342: IF (p_validate_only <> 'T' AND x_return_status = 'S') THEN
343: PA_CI_IMPACTS_pkg.update_row(
344: x_ci_impact_id => p_ci_impact_id,
345: x_ci_id => p_ci_id,
346: x_impact_type_code => p_impact_type_code,
347: x_status_code => p_status_code,

Line 389: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACTS_PVT',

385: ROLLBACK TO update_ci_impact;
386: END IF;
387:
388: x_return_status := 'U';
389: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACTS_PVT',
390: p_procedure_name => 'UPDATE_CI_IMPACT',
391: p_error_text => SUBSTRB(SQLERRM,1,240));
392:
393: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 397: END PA_CI_IMPACTS_pvt;

393: fnd_msg_pub.count_and_get(p_count => x_msg_count,
394: p_data => x_msg_data);
395: END update_ci_impact;
396:
397: END PA_CI_IMPACTS_pvt;