APPS.AK_REGION_PVT dependencies on AK_REGION_LOV_RELATIONS

Line 1508: from AK_REGION_LOV_RELATIONS

1504: p_lov_region_code IN VARCHAR2
1505: ) is
1506: cursor l_get_lov_relations_csr is
1507: select *
1508: from AK_REGION_LOV_RELATIONS
1509: where REGION_APPLICATION_ID = p_region_application_id
1510: and REGION_CODE = p_region_code
1511: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
1512: and ATTRIBUTE_CODE = p_attribute_code;

Line 1516: l_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;

1512: and ATTRIBUTE_CODE = p_attribute_code;
1513: l_api_name CONSTANT varchar2(30) := 'Write_lov_relation_to_buffer';
1514: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1515: l_index NUMBER;
1516: l_lov_relation_rec AK_REGION_LOV_RELATIONS%ROWTYPE;
1517: l_return_status varchar2(1);
1518: begin
1519: -- Retrieve region information from the database
1520:

Line 1965: from ak_region_lov_relations

1961: attribute_code_param varchar2,
1962: lov_region_appl_id_param number,
1963: lov_region_code_param varchar2 ) is
1964: select 1
1965: from ak_region_lov_relations
1966: where region_application_id = region_appl_id_param
1967: and region_code = region_code_param
1968: and attribute_application_id = attribute_appl_id_param
1969: and attribute_code = attribute_code_param

Line 5731: from AK_REGION_LOV_RELATIONS

5727: cursor l_get_lov_relations_csr is
5728: select LOV_REGION_APPL_ID, LOV_REGION_CODE, LOV_ATTRIBUTE_APPL_ID,
5729: LOV_ATTRIBUTE_CODE, BASE_ATTRIBUTE_APPL_ID, BASE_ATTRIBUTE_CODE,
5730: DIRECTION_FLAG, BASE_REGION_APPL_ID, BASE_REGION_CODE
5731: from AK_REGION_LOV_RELATIONS
5732: where region_application_id = p_region_application_id
5733: and region_code = p_region_code
5734: and attribute_application_id = p_attribute_application_id
5735: and attribute_code = p_attribute_code;

Line 5826: -- AK_REGION_LOV_RELATIONS

5822: else
5823: --
5824: -- Otherwise, delete all referencing rows in other tables
5825: --
5826: -- AK_REGION_LOV_RELATIONS
5827: --
5828: open l_get_lov_relations_csr;
5829: loop
5830: fetch l_get_lov_relations_csr into l_lov_region_appl_id,

Line 5835: delete from ak_region_lov_relations

5831: l_lov_region_code, l_lov_attribute_appl_id, l_lov_attribute_code,
5832: l_base_attribute_appl_id, l_base_attribute_code, l_direction_flag,
5833: l_base_region_appl_id, l_base_region_code;
5834: exit when l_get_lov_relations_csr%notfound;
5835: delete from ak_region_lov_relations
5836: where region_application_id = p_region_application_id
5837: and region_code = p_region_code
5838: and attribute_application_id = p_attribute_application_id
5839: and attribute_code = p_attribute_code

Line 6457: from ak_region_lov_relations

6453: region_code_param varchar2,
6454: attribute_appl_id_param number,
6455: attribute_code_param varchar2) is
6456: select distinct lov_region_appl_id, lov_region_code
6457: from ak_region_lov_relations
6458: where region_application_id = region_appl_id_param
6459: and region_code = region_code_param
6460: and attribute_application_id = attribute_appl_id_param
6461: and attribute_code = attribute_code_param;