APPS.PA_CI_IMPACTS_PUB dependencies on PA_CI_IMPACTS

Line 1: PACKAGE BODY PA_CI_IMPACTS_pub AS

1: PACKAGE BODY PA_CI_IMPACTS_pub AS
2: /* $Header: PACIIPPB.pls 120.1 2011/02/01 04:07:44 rmandali ship $ */
3:
4: PROCEDURE create_ci_impact (
5: p_api_version IN NUMBER := 1.0,

Line 42: pa_debug.set_err_stack ('PA_CI_IMPACTS_PUB.CREATE_CI_IMPACTS');

38: and pt.task_name = p_impacted_task_name
39: AND pc.ci_id = p_ci_id;
40:
41: BEGIN
42: pa_debug.set_err_stack ('PA_CI_IMPACTS_PUB.CREATE_CI_IMPACTS');
43:
44: IF p_commit = 'T' THEN
45: SAVEPOINT create_ci_impact;
46: END IF;

Line 81: PA_CI_IMPACTS_pvt.create_ci_impact(

77:
78:
79: IF (p_validate_only <> 'T' AND x_return_status = 'S') THEN
80:
81: PA_CI_IMPACTS_pvt.create_ci_impact(
82: p_api_version => p_api_version,
83: p_init_msg_list => p_init_msg_list,
84: p_commit => p_commit,
85: p_validate_only => p_validate_only,

Line 121: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACTS_PUB',

117: ROLLBACK TO create_ci_impact;
118: END IF;
119:
120: x_return_status := 'U';
121: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACTS_PUB',
122: p_procedure_name => 'CREATE_CI_IMPACT',
123: p_error_text => SUBSTRB(SQLERRM,1,240));
124:
125: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 146: pa_debug.set_err_stack ('PA_CI_IMPACTS_PUB.DELETE_CI_IMPACT');

142: IS
143: l_temp VARCHAR2(1);
144: l_msg_index_out NUMBER;
145: BEGIN
146: pa_debug.set_err_stack ('PA_CI_IMPACTS_PUB.DELETE_CI_IMPACT');
147:
148: IF p_commit = 'T' THEN
149: SAVEPOINT delete_ci_impact;
150: END IF;

Line 163: PA_CI_IMPACTS_pvt.delete_ci_impact(

159:
160: -- Trying to lock the record
161:
162: IF (p_validate_only <> 'T' AND x_return_status = 'S') THEN
163: PA_CI_IMPACTS_pvt.delete_ci_impact(
164: p_api_version => p_api_version,
165: p_init_msg_list => p_init_msg_list,
166: p_commit => p_commit,
167: p_validate_only => p_validate_only,

Line 252: SELECT * FROM pa_ci_impacts

248: AND pc.ci_id = p_ci_id;
249:
250: CURSOR get_ci_info
251: IS
252: SELECT * FROM pa_ci_impacts
253: WHERE ci_impact_id = p_ci_impact_id;
254:
255: BEGIN
256: pa_debug.set_err_stack ('PA_CI_IMPACTS_PUB.CREATE_CI_IMPACTS');

Line 256: pa_debug.set_err_stack ('PA_CI_IMPACTS_PUB.CREATE_CI_IMPACTS');

252: SELECT * FROM pa_ci_impacts
253: WHERE ci_impact_id = p_ci_impact_id;
254:
255: BEGIN
256: pa_debug.set_err_stack ('PA_CI_IMPACTS_PUB.CREATE_CI_IMPACTS');
257:
258: IF p_commit = 'T' THEN
259: SAVEPOINT update_ci_impact;
260: END IF;

Line 321: PA_CI_IMPACTS_pvt.update_ci_impact(

317: l_task_id := rec.impacted_task_id;
318: END IF;
319:
320:
321: PA_CI_IMPACTS_pvt.update_ci_impact(
322: p_api_version => p_api_version,
323: p_init_msg_list => p_init_msg_list,
324: p_commit => p_commit,
325: p_validate_only => p_validate_only,

Line 379: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACTS_PUB',

375: ROLLBACK TO update_ci_impact;
376: END IF;
377:
378: x_return_status := 'U';
379: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACTS_PUB',
380: p_procedure_name => 'UPDATE_CI_IMPACT',
381: p_error_text => SUBSTRB(SQLERRM,1,240));
382:
383: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 387: END PA_CI_IMPACTS_pub;

383: fnd_msg_pub.count_and_get(p_count => x_msg_count,
384: p_data => x_msg_data);
385: END update_ci_impact;
386:
387: END PA_CI_IMPACTS_pub;