DBA Data[Home] [Help]

APPS.CS_CF_UPG_UTL_PKG dependencies on AK_REGION_ITEMS

Line 2179: FROM ak_region_items a,

2175: l_attribute12,
2176: l_attribute13,
2177: l_attribute14,
2178: l_attribute15
2179: FROM ak_region_items a,
2180: ak_region_items_tl b
2181: WHERE a.region_code = b.region_code
2182: AND a.region_application_id = b.region_application_id
2183: AND a.attribute_code = b.attribute_code

Line 2180: ak_region_items_tl b

2176: l_attribute13,
2177: l_attribute14,
2178: l_attribute15
2179: FROM ak_region_items a,
2180: ak_region_items_tl b
2181: WHERE a.region_code = b.region_code
2182: AND a.region_application_id = b.region_application_id
2183: AND a.attribute_code = b.attribute_code
2184: AND a.attribute_application_id = b.attribute_application_id

Line 2195: AK_REGION_ITEMS_PKG.UPDATE_ROW(

2191:
2192:
2193: IF (p_subRegionCode is null) THEN
2194:
2195: AK_REGION_ITEMS_PKG.UPDATE_ROW(
2196: X_REGION_APPLICATION_ID => 672,
2197: X_REGION_CODE => p_regionCode,
2198: X_ATTRIBUTE_APPLICATION_ID => 672,
2199: X_ATTRIBUTE_CODE => p_attributeCode,

Line 2277: AK_REGION_ITEMS_PKG.UPDATE_ROW(

2273: X_ATTRIBUTE13 => l_attribute13,
2274: X_ATTRIBUTE14 => l_attribute14,
2275: X_ATTRIBUTE15 => l_attribute15);
2276: ELSE
2277: AK_REGION_ITEMS_PKG.UPDATE_ROW(
2278: X_REGION_APPLICATION_ID => 672,
2279: X_REGION_CODE => p_regionCode,
2280: X_ATTRIBUTE_APPLICATION_ID => 672,
2281: X_ATTRIBUTE_CODE => p_attributeCode,