APPS.QA_AK_MAPPING_API dependencies on AK_REGIONS

Line 870: FROM ak_regions

866: dummy VARCHAR2(6);
867:
868: CURSOR c IS
869: SELECT 'TRUE'
870: FROM ak_regions
871: WHERE region_application_id = p_region_application_id
872: AND region_code = p_region_code;
873:
874: BEGIN

Line 886: ak_regions_pkg.delete_row(p_region_application_id,

882: CLOSE c;
883:
884: IF (l_row_exists = 'TRUE') THEN
885: -- dbms_output.put_line('Deleting Region : ' || p_region_code);
886: ak_regions_pkg.delete_row(p_region_application_id,
887: p_region_code);
888: END IF;
889:
890: END delete_region;

Line 1414: -- This procedure creates an entry in ak regions table for a collection

1410: WHERE plan_id = p_plan_id;
1411:
1412: BEGIN
1413:
1414: -- This procedure creates an entry in ak regions table for a collection
1415: -- plan in Quality.
1416:
1417: OPEN c;
1418: FETCH c INTO l_qa_plans_row;

Line 1426: AK_REGIONS_PKG.insert_row (

1422: delete_region (p_region_application_id, l_region_code);
1423:
1424: l_region_style := get_region_style(l_region_code);
1425:
1426: AK_REGIONS_PKG.insert_row (
1427: X_ROWID => l_row_id,
1428: X_REGION_APPLICATION_ID => p_region_application_id,
1429: X_REGION_CODE => l_region_code,
1430: X_DATABASE_OBJECT_NAME => 'ICX_PROMPTS',