APPS.PA_OBJECT_REGIONS_PVT dependencies on PA_OBJECT_REGIONS

Line 1: PACKAGE BODY PA_OBJECT_REGIONS_PVT AS

1: PACKAGE BODY PA_OBJECT_REGIONS_PVT AS
2: --$Header: PAAPORVB.pls 120.2 2005/08/19 16:16:02 mwasowic noship $
3:
4: procedure create_object_page_region (
5: p_api_version IN NUMBER := 1.0,

Line 21: FROM pa_object_regions

17: ) IS
18: CURSOR check_object_page_region_exits
19: IS
20: SELECT 'X'
21: FROM pa_object_regions
22: WHERE object_id = p_object_id
23: AND object_type = p_object_type
24: AND placeholder_reg_code = p_placeholder_reg_code;
25:

Line 64: -- Insert into pa_object_regions

60: open check_object_page_region_exits;
61: fetch check_object_page_region_exits into l_dummy;
62: if (check_object_page_region_exits%NOTFOUND) then
63: close check_object_page_region_exits;
64: -- Insert into pa_object_regions
65: IF (p_validate_only <>FND_API.g_true
66: AND x_return_status = FND_API.g_ret_sts_success) THEN
67:
68: PA_OBJECT_REGIONS_PKG.insert_row(

Line 68: PA_OBJECT_REGIONS_PKG.insert_row(

64: -- Insert into pa_object_regions
65: IF (p_validate_only <>FND_API.g_true
66: AND x_return_status = FND_API.g_ret_sts_success) THEN
67:
68: PA_OBJECT_REGIONS_PKG.insert_row(
69: P_OBJECT_ID ,
70: P_OBJECT_TYPE ,
71: P_PLACEHOLDER_REG_CODE ,
72: P_REPLACEMENT_REG_CODE ,

Line 100: ( p_pkg_name => 'PA_OBJECT_REGIONS_PVT.create_object_page_region'

96: ROLLBACK TO create_object_page_region;
97: END IF;
98: -- Set the excetption Message and the stack
99: FND_MSG_PUB.add_exc_msg
100: ( p_pkg_name => 'PA_OBJECT_REGIONS_PVT.create_object_page_region'
101: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
102: --
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
104: RAISE; -- This is optional depending on the needs

Line 126: FROM pa_object_regions

122: is
123: CURSOR check_object_page_region_exits
124: IS
125: SELECT 'X'
126: FROM pa_object_regions
127: WHERE object_id = p_object_id
128: AND object_type = p_object_type
129: AND placeholder_reg_code = p_placeholder_reg_code;
130:

Line 167: PA_OBJECT_REGIONS_PKG.DELETE_ROW (

163: close check_valid_region;
164: -- Delete the association if the replacement region code is null
165: IF (P_REPLACEMENT_REG_CODE IS NULL) THEN
166:
167: PA_OBJECT_REGIONS_PKG.DELETE_ROW (
168: P_OBJECT_ID ,
169: P_OBJECT_TYPE ,
170: P_PLACEHOLDER_REG_CODE );
171: RETURN;

Line 173: -- Update pa_object_regions

169: P_OBJECT_TYPE ,
170: P_PLACEHOLDER_REG_CODE );
171: RETURN;
172: END IF;
173: -- Update pa_object_regions
174: IF (p_validate_only <>FND_API.g_true
175: AND x_return_status = FND_API.g_ret_sts_success) THEN
176:
177: PA_OBJECT_REGIONS_PKG.update_row(

Line 177: PA_OBJECT_REGIONS_PKG.update_row(

173: -- Update pa_object_regions
174: IF (p_validate_only <>FND_API.g_true
175: AND x_return_status = FND_API.g_ret_sts_success) THEN
176:
177: PA_OBJECT_REGIONS_PKG.update_row(
178: P_OBJECT_ID ,
179: P_OBJECT_TYPE ,
180: P_PLACEHOLDER_REG_CODE ,
181: P_REPLACEMENT_REG_CODE ,

Line 212: ( p_pkg_name => 'PA_OBJECT_REGIONS_PVT.update_object_page_region'

208: ROLLBACK TO update_object_page_region;
209: END IF;
210: -- Set the excetption Message and the stack
211: FND_MSG_PUB.add_exc_msg
212: ( p_pkg_name => 'PA_OBJECT_REGIONS_PVT.update_object_page_region'
213: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
214: --
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
216: RAISE; -- This is optional depending on the needs

Line 248: PA_OBJECT_REGIONS_PKG.delete_row(

244:
245: IF (p_validate_only <>FND_API.g_true
246: AND x_return_status = FND_API.g_ret_sts_success) THEN
247:
248: PA_OBJECT_REGIONS_PKG.delete_row(
249: P_OBJECT_ID ,
250: P_OBJECT_TYPE ,
251: P_PLACEHOLDER_REG_CODE );
252: END IF;

Line 270: ( p_pkg_name => 'PA_OBJECT_REGIONS_PVT.delete_object_page_region'

266: ROLLBACK TO delete_object_page_region;
267: END IF;
268: -- Set the excetption Message and the stack
269: FND_MSG_PUB.add_exc_msg
270: ( p_pkg_name => 'PA_OBJECT_REGIONS_PVT.delete_object_page_region'
271: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
272: --
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
274: RAISE; -- This is optional depending on the needs

Line 278: END PA_OBJECT_REGIONS_PVT;

274: RAISE; -- This is optional depending on the needs
275:
276: End DELETE_object_page_region;
277:
278: END PA_OBJECT_REGIONS_PVT;