DBA Data[Home] [Help]

APPS.PA_PAGE_LAYOUT_PKG dependencies on PA_PAGE_LAYOUT_REGIONS

Line 183: cursor C is select ROWID from PA_PAGE_LAYOUT_REGIONS

179: ) IS
180:
181: l_row_id ROWID;
182:
183: cursor C is select ROWID from PA_PAGE_LAYOUT_REGIONS
184: where PAGE_ID = P_PAGE_ID
185: and REGION_SOURCE_TYPE = p_REGION_SOURCE_TYPE
186: and REGION_SOURCE_CODE = P_REGION_SOURCE_CODE
187: ;

Line 192: insert into PA_PAGE_LAYOUT_REGIONS (

188: BEGIN
189:
190: x_return_status := FND_API.G_RET_STS_SUCCESS;
191:
192: insert into PA_PAGE_LAYOUT_REGIONS (
193: PAGE_ID,
194: REGION_SOURCE_TYPE,
195: REGION_SOURCE_CODE,
196: VIEW_REGION_CODE,

Line 252: delete from PA_PAGE_LAYOUT_REGIONS

248:
249: x_return_status := FND_API.G_RET_STS_SUCCESS;
250:
251:
252: delete from PA_PAGE_LAYOUT_REGIONS
253: where PAGE_ID = P_PAGE_ID
254: and REGION_SOURCE_TYPE = p_REGION_SOURCE_TYPE
255: and REGION_SOURCE_CODE = P_REGION_SOURCE_CODE
256: and nvl(p_record_version_number, record_version_number) = record_version_number;