APPS.CS_CF_UPG_UTL_PKG dependencies on AK_REGIONS

Line 1806: r_rec ak_regions%rowtype;

1802: p_newRegionApplId IN NUMBER,
1803: p_checkRegion IN BOOLEAN)
1804: IS
1805:
1806: r_rec ak_regions%rowtype;
1807:
1808: CURSOR r_csr (p_csr_code IN VARCHAR2, p_csr_id IN NUMBER) is
1809: SELECT *
1810: FROM ak_regions

Line 1810: FROM ak_regions

1806: r_rec ak_regions%rowtype;
1807:
1808: CURSOR r_csr (p_csr_code IN VARCHAR2, p_csr_id IN NUMBER) is
1809: SELECT *
1810: FROM ak_regions
1811: WHERE region_code = p_csr_code
1812: AND region_application_id = p_csr_id;
1813:
1814: CURSOR region_exists (p_region_code IN VARCHAR2, p_region_application_id IN NUMBER) IS

Line 1816: FROM ak_regions

1812: AND region_application_id = p_csr_id;
1813:
1814: CURSOR region_exists (p_region_code IN VARCHAR2, p_region_application_id IN NUMBER) IS
1815: SELECT count(*)
1816: FROM ak_regions
1817: where region_code = p_region_code
1818: AND region_application_id = p_region_application_id;
1819:
1820:

Line 1846: AK_REGIONS2_PKG.copy_records(p_regionCode,

1842: -- after the ldt is uploaded.
1843:
1844: IF ((p_checkRegion AND l_count = 0) OR NOT p_checkRegion) THEN
1845:
1846: AK_REGIONS2_PKG.copy_records(p_regionCode,
1847: p_regionApplId,
1848: p_newRegionCode,
1849: p_newRegionApplId);
1850:

Line 1868: AK_REGIONS_PKG.Update_Row(X_REGION_APPLICATION_ID => r_rec.region_application_id,

1864:
1865: -- mkcyee 02/24/2004 After we clone the region, we need to update
1866: -- the region name; Otherwise, it uses the same name as the region we
1867: -- are trying to clone
1868: AK_REGIONS_PKG.Update_Row(X_REGION_APPLICATION_ID => r_rec.region_application_id,
1869: X_REGION_CODE => r_rec.region_code,
1870: X_DATABASE_OBJECT_NAME => r_rec.database_object_name,
1871: X_REGION_STYLE => r_rec.region_style,
1872: X_NUM_COLUMNS => r_rec.num_columns,

Line 2540: FROM ak_regions

2536:
2537: l_count number := 0;
2538: BEGIN
2539: SELECT count(*) INTO l_count
2540: FROM ak_regions
2541: WHERE region_code in ('IBU_CF_SR_10_'|| p_suffix,
2542: 'IBU_CF_SR_20_' || p_suffix,
2543: 'IBU_CF_SR_30_' || p_suffix,
2544: 'IBU_CF_SR_40_' || p_suffix,