APPS.PA_PAGE_LAYOUT_UTILS dependencies on PA_OBJECT_REGIONS

Line 102: FROM pa_object_regions

98: IS
99: SELECT
100: placeholder_reg_code
101: , replacement_reg_code
102: FROM pa_object_regions
103: where object_type = p_object_type
104: and object_id = p_object_id_from;
105:
106: l_commit_flag varchar2(1) := 'Y';

Line 207: PA_OBJECT_REGIONS_PKG.INSERT_ROW (

203:
204: /* Copy the object_regions */
205:
206: FOR obj_regions_rec in obj_regions LOOP
207: PA_OBJECT_REGIONS_PKG.INSERT_ROW (
208: P_OBJECT_ID => p_object_id_to ,
209: P_OBJECT_TYPE => p_object_type ,
210: P_PLACEHOLDER_REG_CODE => obj_regions_rec.PLACEHOLDER_REG_CODE ,
211: P_REPLACEMENT_REG_CODE => obj_regions_rec.REPLACEMENT_REG_CODE ,

Line 253: FROM pa_object_regions

249: )
250: IS
251: CURSOR C IS
252: SELECT replacement_reg_code
253: FROM pa_object_regions
254: WHERE object_type = p_object_type
255: AND object_id = P_object_id
256: --AND placeholder_reg_code = 'PA_PROJECT_INFO'; --Bug 3745737
257: AND placeholder_reg_code = '/oracle/apps/pa/project/webui/ProjectInfoRN';

Line 259: l_replacement_reg_code pa_object_regions.replacement_reg_code%TYPE := null;

255: AND object_id = P_object_id
256: --AND placeholder_reg_code = 'PA_PROJECT_INFO'; --Bug 3745737
257: AND placeholder_reg_code = '/oracle/apps/pa/project/webui/ProjectInfoRN';
258:
259: l_replacement_reg_code pa_object_regions.replacement_reg_code%TYPE := null;
260:
261: BEGIN
262: -- Initialize the out parameters
263: x_customer_exists := 'N';