APPS.PA_PLAN_RES_DEFAULTS_PUB dependencies on PA_PLAN_RES_DEFAULTS

Line 1: package body pa_plan_res_defaults_pub as

1: package body pa_plan_res_defaults_pub as
2: /* $Header: PARPRDPB.pls 120.1 2007/02/06 09:55:49 dthakker ship $ */
3: procedure UPDATE_RESOURCE_DEFAULTS (
4: P_PLAN_RES_DEF_ID_TBL IN system.pa_num_tbl_type ,
5: P_RESOURCE_CLASS_ID_TBL IN system.pa_num_tbl_type ,

Line 46: from PA_PLAN_RES_DEFAULTS

42: -- Get the existing Item Master and Item Category.
43: BEGIN
44: select ITEM_CATEGORY_SET_ID, ITEM_MASTER_ID
45: into l_item_category_set_id, l_item_master_id
46: from PA_PLAN_RES_DEFAULTS
47: where PLAN_RES_DEFAULT_ID = P_PLAN_RES_DEF_ID_TBL(i);
48:
49: EXCEPTION
50: WHEN NO_DATA_FOUND THEN

Line 55: --p_pkg_name => 'pa_plan_res_defaults_pub',

51: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
52: x_msg_count := x_msg_count + 1;
53: RETURN;
54: --FND_MSG_PUB.add_exc_msg(
55: --p_pkg_name => 'pa_plan_res_defaults_pub',
56: --p_procedure_name => 'UPDATE_RESOURCE_DEFAULTS');
57: END;
58: -- Check whether Item Master is used anywhere
59: IF l_item_master_id IS NOT NULL THEN

Line 151: pa_plan_res_defaults_pvt.UPDATE_ROW (

147: raise l_category_error;
148: END IF;
149:
150: --hr_utility.trace('before UPDATE_ROW ');
151: pa_plan_res_defaults_pvt.UPDATE_ROW (
152: P_PLAN_RES_DEFAULT_ID => P_PLAN_RES_DEF_ID_TBL(i) ,
153: P_RESOURCE_CLASS_ID => P_RESOURCE_CLASS_ID_TBL(i) ,
154: P_OBJECT_TYPE => P_OBJECT_TYPE_TBL(i) ,
155: P_OBJECT_ID => P_OBJECT_ID_TBL(i) ,

Line 201: -- p_pkg_name => 'pa_plan_res_defaults_pub.UPDATE_RESOURCE_DEFAULTS'

197: x_msg_count := x_msg_count + 1;
198: pa_utils.add_message('PA', x_msg_data);
199: WHEN OTHERS THEN
200: -- FND_MSG_PUB.add_exc_msg(
201: -- p_pkg_name => 'pa_plan_res_defaults_pub.UPDATE_RESOURCE_DEFAULTS'
202: -- ,p_procedure_name => PA_DEBUG.G_Err_Stack);
203: x_msg_count := x_msg_count + 1;
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: x_msg_data := substr(SQLERRM, 1, 25);

Line 209: end pa_plan_res_defaults_pub;

205: x_msg_data := substr(SQLERRM, 1, 25);
206:
207: end UPDATE_RESOURCE_DEFAULTS;
208:
209: end pa_plan_res_defaults_pub;