APPS.AK_REGION_PVT dependencies on AK_CATEGORY_USAGES

Line 1328: from AK_CATEGORY_USAGES

1324: p_attribute_code IN VARCHAR2
1325: ) is
1326: cursor l_get_category_usages_csr is
1327: select *
1328: from AK_CATEGORY_USAGES
1329: where REGION_APPLICATION_ID = p_region_application_id
1330: and REGION_CODE = p_region_code
1331: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
1332: and ATTRIBUTE_CODE = p_attribute_code;

Line 1336: l_category_usage_rec AK_CATEGORY_USAGES%ROWTYPE;

1332: and ATTRIBUTE_CODE = p_attribute_code;
1333: l_api_name CONSTANT varchar2(50) := 'Write_category_usages_to_buffer';
1334: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1335: l_index NUMBER;
1336: l_category_usage_rec AK_CATEGORY_USAGES%ROWTYPE;
1337: l_return_status varchar2(1);
1338: begin
1339: -- Retrieve region information from the database
1340:

Line 1977: from ak_category_usages acu, ak_region_items ari

1973: region_code_param varchar2,
1974: attribute_appl_id_param number,
1975: attribute_code_param varchar2) is
1976: select 1
1977: from ak_category_usages acu, ak_region_items ari
1978: where acu.region_code = region_code_param
1979: and acu.region_application_id = region_appl_id_param
1980: and acu.attribute_code = attribute_code_param
1981: and acu.attribute_application_id = attribute_appl_id_param

Line 5749: from AK_CATEGORY_USAGES

5745: and attribute_application_id = p_attribute_application_id
5746: and attribute_code = p_attribute_code;
5747: cursor l_get_category_usages_csr is
5748: select CATEGORY_ID
5749: from AK_CATEGORY_USAGES
5750: where region_application_id = p_region_application_id
5751: and region_code = p_region_code
5752: and attribute_application_id = p_attribute_application_id
5753: and attribute_code = p_attribute_code;

Line 5873: -- AK_CATEGORY_USAGES

5869: end loop;
5870: close l_get_lov_relations_csr;
5871:
5872: --
5873: -- AK_CATEGORY_USAGES
5874: --
5875: open l_get_category_usages_csr;
5876: loop
5877: fetch l_get_category_usages_csr into l_category_id;

Line 5879: delete from ak_category_usages

5875: open l_get_category_usages_csr;
5876: loop
5877: fetch l_get_category_usages_csr into l_category_id;
5878: exit when l_get_category_usages_csr%notfound;
5879: delete from ak_category_usages
5880: where region_application_id = p_region_application_id
5881: and region_code = p_region_code
5882: and attribute_application_id = p_attribute_application_id
5883: and attribute_code = p_attribute_code