APPS.PA_PAGE_TYPE_REGION_PKG dependencies on PA_PAGE_TYPE_REGIONS

Line 30: FROM pa_page_type_regions

26: l_row_id ROWID;
27:
28: CURSOR c1 IS
29: SELECT rowid
30: FROM pa_page_type_regions
31: WHERE page_type_code = p_page_type_code
32: AND region_source_type = p_region_source_type
33: AND region_source_code = p_region_source_code;
34:

Line 37: insert into PA_PAGE_TYPE_REGIONS (

33: AND region_source_code = p_region_source_code;
34:
35: begin
36:
37: insert into PA_PAGE_TYPE_REGIONS (
38: PAGE_TYPE_CODE,
39: VIEW_REGION_CODE,
40: EDIT_REGION_CODE,
41: DISPLAY_ORDER,

Line 125: FROM pa_page_type_regions

121: l_row_id ROWID;
122:
123: CURSOR c1 IS
124: SELECT rowid
125: FROM pa_page_type_regions
126: WHERE page_type_code = p_page_type_code
127: AND region_source_type = p_region_source_type
128: AND region_source_code = p_region_source_code;
129:

Line 132: UPDATE PA_PAGE_TYPE_REGIONS SET

128: AND region_source_code = p_region_source_code;
129:
130: BEGIN
131:
132: UPDATE PA_PAGE_TYPE_REGIONS SET
133: view_region_code = P_VIEW_REGION_CODE,
134: edit_region_code = P_EDIT_REGION_CODE,
135: display_order = Decode(p_display_order, 1.7e20, display_order, p_display_order),
136: mandatory_flag = Decode(p_mandatory_flag, '^', mandatory_flag,p_mandatory_flag ),

Line 179: delete from PA_PAGE_TYPE_REGIONS

175: ) is
176: BEGIN
177:
178: IF p_rowid IS NOT NULL THEN
179: delete from PA_PAGE_TYPE_REGIONS
180: where rowid = p_rowid;
181: ELSE
182:
183: delete from PA_PAGE_TYPE_REGIONS

Line 183: delete from PA_PAGE_TYPE_REGIONS

179: delete from PA_PAGE_TYPE_REGIONS
180: where rowid = p_rowid;
181: ELSE
182:
183: delete from PA_PAGE_TYPE_REGIONS
184: where PAGE_TYPE_CODE = p_page_type_code
185: AND region_source_type = p_region_source_type
186: AND region_source_code = p_region_source_code;
187: END IF;