APPS.PA_PAGE_LAYOUT_UTILS dependencies on PA_OBJECT_REGIONS

Line 100: FROM pa_object_regions

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

Line 198: PA_OBJECT_REGIONS_PKG.INSERT_ROW (

194:
195: /* Copy the object_regions */
196:
197: FOR obj_regions_rec in obj_regions LOOP
198: PA_OBJECT_REGIONS_PKG.INSERT_ROW (
199: P_OBJECT_ID => p_object_id_to ,
200: P_OBJECT_TYPE => p_object_type ,
201: P_PLACEHOLDER_REG_CODE => obj_regions_rec.PLACEHOLDER_REG_CODE ,
202: P_REPLACEMENT_REG_CODE => obj_regions_rec.REPLACEMENT_REG_CODE ,

Line 244: FROM pa_object_regions

240: )
241: IS
242: CURSOR C IS
243: SELECT replacement_reg_code
244: FROM pa_object_regions
245: WHERE object_type = p_object_type
246: AND object_id = P_object_id
247: --AND placeholder_reg_code = 'PA_PROJECT_INFO'; --Bug 3745737
248: AND placeholder_reg_code = '/oracle/apps/pa/project/webui/ProjectInfoRN';

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

246: AND object_id = P_object_id
247: --AND placeholder_reg_code = 'PA_PROJECT_INFO'; --Bug 3745737
248: AND placeholder_reg_code = '/oracle/apps/pa/project/webui/ProjectInfoRN';
249:
250: l_replacement_reg_code pa_object_regions.replacement_reg_code%TYPE := null;
251:
252: BEGIN
253: -- Initialize the out parameters
254: x_customer_exists := 'N';