DBA Data[Home] [Help]

APPS.AK_OBJECT2_PVT dependencies on AK_REGION_PVT

Line 2349: AK_REGION_PVT.INSERT_REGION_PK_TABLE (

2345: open l_get_regions_csr(l_object_pk_tbl(l_index));
2346: loop
2347: fetch l_get_regions_csr into l_region_appl_id, l_region_code;
2348: exit when (l_get_regions_csr%notfound);
2349: AK_REGION_PVT.INSERT_REGION_PK_TABLE (
2350: p_return_status => l_return_status,
2351: p_region_application_id => l_region_appl_id,
2352: p_region_code => l_region_code,
2353: p_region_pk_tbl => l_region_pk_tbl);

Line 2364: AK_REGION_PVT.INSERT_REGION_PK_TABLE (

2360: open l_get_attr_lov_regions_csr(l_object_pk_tbl(l_index));
2361: loop
2362: fetch l_get_attr_lov_regions_csr into l_region_appl_id, l_region_code;
2363: exit when (l_get_attr_lov_regions_csr%notfound);
2364: AK_REGION_PVT.INSERT_REGION_PK_TABLE (
2365: p_return_status => l_return_status,
2366: p_region_application_id => l_region_appl_id,
2367: p_region_code => l_region_code,
2368: p_region_pk_tbl => l_region_pk_tbl);

Line 2376: AK_REGION_PVT.INSERT_REGION_PK_TABLE (

2372: open l_get_objattr_lov_regions_csr(l_object_pk_tbl(l_index));
2373: loop
2374: fetch l_get_objattr_lov_regions_csr into l_region_appl_id,l_region_code;
2375: exit when (l_get_objattr_lov_regions_csr%notfound);
2376: AK_REGION_PVT.INSERT_REGION_PK_TABLE (
2377: p_return_status => l_return_status,
2378: p_region_application_id => l_region_appl_id,
2379: p_region_code => l_region_code,
2380: p_region_pk_tbl => l_region_pk_tbl);

Line 2400: AK_REGION_PVT.INSERT_REGION_PK_TABLE (

2396: loop
2397: fetch l_get_region_lov_regions_csr into l_region_appl_id,
2398: l_region_code;
2399: exit when (l_get_region_lov_regions_csr%notfound);
2400: AK_REGION_PVT.INSERT_REGION_PK_TABLE (
2401: p_return_status => l_return_status,
2402: p_region_application_id => l_region_appl_id,
2403: p_region_code => l_region_code,
2404: p_region_pk_tbl => l_region_pk_tbl);

Line 2559: AK_REGION_PVT.DOWNLOAD_REGION (

2555: end loop;
2556: */
2557:
2558: if (l_region_pk_tbl.count > 0) then
2559: AK_REGION_PVT.DOWNLOAD_REGION (
2560: p_validation_level => p_validation_level,
2561: p_api_version_number => 1.0,
2562: p_return_status => l_return_status,
2563: p_region_pk_tbl => l_region_pk_tbl,