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 5738: from AK_CATEGORY_USAGES

5734: and attribute_application_id = p_attribute_application_id
5735: and attribute_code = p_attribute_code;
5736: cursor l_get_category_usages_csr is
5737: select CATEGORY_ID
5738: from AK_CATEGORY_USAGES
5739: where region_application_id = p_region_application_id
5740: and region_code = p_region_code
5741: and attribute_application_id = p_attribute_application_id
5742: and attribute_code = p_attribute_code;

Line 5862: -- AK_CATEGORY_USAGES

5858: end loop;
5859: close l_get_lov_relations_csr;
5860:
5861: --
5862: -- AK_CATEGORY_USAGES
5863: --
5864: open l_get_category_usages_csr;
5865: loop
5866: fetch l_get_category_usages_csr into l_category_id;

Line 5868: delete from ak_category_usages

5864: open l_get_category_usages_csr;
5865: loop
5866: fetch l_get_category_usages_csr into l_category_id;
5867: exit when l_get_category_usages_csr%notfound;
5868: delete from ak_category_usages
5869: where region_application_id = p_region_application_id
5870: and region_code = p_region_code
5871: and attribute_application_id = p_attribute_application_id
5872: and attribute_code = p_attribute_code