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.0 2005/05/29 13:25:23 appldev noship $ */
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 78: PA_CI_IMPACTS_pvt.create_ci_impact(

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

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

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

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

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

Line 160: PA_CI_IMPACTS_pvt.delete_ci_impact(

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

Line 249: SELECT * FROM pa_ci_impacts

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

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

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

Line 315: PA_CI_IMPACTS_pvt.update_ci_impact(

311: l_task_id := rec.impacted_task_id;
312: END IF;
313:
314:
315: PA_CI_IMPACTS_pvt.update_ci_impact(
316: p_api_version => p_api_version,
317: p_init_msg_list => p_init_msg_list,
318: p_commit => p_commit,
319: p_validate_only => p_validate_only,

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

369: ROLLBACK TO update_ci_impact;
370: END IF;
371:
372: x_return_status := 'U';
373: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_CI_IMPACTS_PUB',
374: p_procedure_name => 'UPDATE_CI_IMPACT',
375: p_error_text => SUBSTRB(SQLERRM,1,240));
376:
377: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 381: END PA_CI_IMPACTS_pub;

377: fnd_msg_pub.count_and_get(p_count => x_msg_count,
378: p_data => x_msg_data);
379: END update_ci_impact;
380:
381: END PA_CI_IMPACTS_pub;