eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_REGION2_PVT dependencies on AK_REGION2_PVT

Line 1: package body AK_REGION2_PVT as

1: package body AK_REGION2_PVT as
2: /* $Header: akdvre2b.pls 120.4 2006/11/30 23:19:34 tshort ship $ */
3:
4: --=======================================================
5: -- Procedure UPLOAD_REGION

Line 2421: if AK_REGION2_PVT.LOV_RELATION_EXISTS (

2417: end if;
2418: if ( l_lov_relation_tbl(l_index).base_region_code is null ) then
2419: l_lov_relation_tbl(l_index).base_region_code := l_lov_relation_tbl(l_index).region_code;
2420: end if;
2421: if AK_REGION2_PVT.LOV_RELATION_EXISTS (
2422: p_api_version_number => 1.0,
2423: p_return_status => l_return_status,
2424: p_region_application_id =>
2425: l_lov_relation_tbl(l_index).region_application_id,

Line 2446: AK_REGION2_PVT.UPDATE_LOV_RELATION (

2442: -- Also update Region Lov relations if G_NO_CUSTOM_UPDATE since there's
2443: -- no customized data in this table, do not update if G_NO_UPDATE_MODE
2444: --
2445: if (AK_UPLOAD_GRP.G_UPDATE_MODE or AK_UPLOAD_GRP.G_NO_CUSTOM_UPDATE) then
2446: AK_REGION2_PVT.UPDATE_LOV_RELATION (
2447: p_validation_level => p_validation_level,
2448: p_api_version_number => 1.0,
2449: p_msg_count => l_msg_count,
2450: p_msg_data => l_msg_data,

Line 2479: AK_REGION2_PVT.CREATE_LOV_RELATION (

2475: p_copy_redo_flag => l_copy_redo_flag
2476: );
2477: end if;
2478: else
2479: AK_REGION2_PVT.CREATE_LOV_RELATION (
2480: p_validation_level => p_validation_level,
2481: p_api_version_number => 1.0,
2482: p_msg_count => l_msg_count,
2483: p_msg_data => l_msg_data,

Line 2560: if ( AK_REGION2_PVT.CATEGORY_USAGE_EXISTS(

2556: close l_check_fnd_category_id_csr;
2557: end if;
2558:
2559: if (l_category_usage_tbl(l_index).category_name is not null) then
2560: if ( AK_REGION2_PVT.CATEGORY_USAGE_EXISTS(
2561: p_api_version_number => 1.0,
2562: p_return_status => l_return_status,
2563: p_region_application_id =>
2564: l_category_usage_tbl(l_index).region_application_id,

Line 2570: AK_REGION2_PVT.CREATE_CATEGORY_USAGE (

2566: p_attribute_application_id =>
2567: l_category_usage_tbl(l_index).attribute_application_id,
2568: p_attribute_code => l_category_usage_tbl(l_index).attribute_code,
2569: p_category_name => l_category_usage_tbl(l_index).category_name) = false) then
2570: AK_REGION2_PVT.CREATE_CATEGORY_USAGE (
2571: p_validation_level => p_validation_level,
2572: p_api_version_number => 1.0,
2573: p_msg_count => l_msg_count,
2574: p_msg_data => l_msg_data,

Line 2596: AK_REGION2_PVT.UPDATE_CATEGORY_USAGE (

2592: p_pass => p_pass,
2593: p_copy_redo_flag => l_copy_redo_flag
2594: );
2595: else
2596: AK_REGION2_PVT.UPDATE_CATEGORY_USAGE (
2597: p_validation_level => p_validation_level,
2598: p_api_version_number => 1.0,
2599: p_msg_count => l_msg_count,
2600: p_msg_data => l_msg_data,

Line 2768: if (AK_REGION2_PVT.GRAPH_COLUMN_EXISTS(

2764: --
2765: if (l_graph_column_tbl.count > 0) then
2766: for l_index in l_graph_column_tbl.FIRST .. l_graph_column_tbl.LAST loop
2767: if (l_graph_column_tbl.exists(l_index)) then
2768: if (AK_REGION2_PVT.GRAPH_COLUMN_EXISTS(
2769: p_api_version_number => 1.0,
2770: p_return_status => l_return_status,
2771: p_region_application_id => l_graph_column_tbl(l_index).region_application_id,
2772: p_region_code => l_graph_column_tbl(l_index).region_code,

Line 2780: AK_REGION2_PVT.UPDATE_GRAPH_COLUMN (

2776: /* --
2777: -- Update Region graph columns if G_UPDATE_MODE is TRUE
2778: --
2779: if (AK_UPLOAD_GRP.G_UPDATE_MODE) then
2780: AK_REGION2_PVT.UPDATE_GRAPH_COLUMN (
2781: p_validation_level => p_validation_level,
2782: p_api_version_number => 1.0,
2783: p_msg_count => l_msg_count,
2784: p_msg_data => l_msg_data,

Line 2810: AK_REGION2_PVT.UPDATE_GRAPH_COLUMN (

2806: and graph_number = l_graph_column_tbl(l_index).graph_number
2807: and attribute_application_id = l_graph_column_tbl(l_index).attribute_application_id
2808: and attribute_code = l_graph_column_tbl(l_index).attribute_code;
2809: if ( l_user_id1 = 1 or l_user_id1 = 2) then
2810: AK_REGION2_PVT.UPDATE_GRAPH_COLUMN (
2811: p_validation_level => p_validation_level,
2812: p_api_version_number => 1.0,
2813: p_msg_count => l_msg_count,
2814: p_msg_data => l_msg_data,

Line 2834: AK_REGION2_PVT.CREATE_GRAPH_COLUMN (

2830: end if; */ /*if l_user_id1 = 1 */ /*
2831: end if; -- */ /* if G_UPDATE_MODE G_NO_CUSTOM_UPDATE */ /*
2832: else */
2833: /*
2834: AK_REGION2_PVT.CREATE_GRAPH_COLUMN (
2835: p_validation_level => p_validation_level,
2836: p_api_version_number => 1.0,
2837: p_msg_count => l_msg_count,
2838: p_msg_data => l_msg_data,

Line 3547: if AK_REGION2_PVT.LOV_RELATION_EXISTS (

3543: if ( G_LOV_RELATION_REDO_TBL(l_index).base_region_code is null ) then
3544: G_LOV_RELATION_REDO_TBL(l_index).base_region_code := G_LOV_RELATION_REDO_TBL(l_index).region_code;
3545: end if;
3546:
3547: if AK_REGION2_PVT.LOV_RELATION_EXISTS (
3548: p_api_version_number => 1.0,
3549: p_return_status => l_return_status,
3550: p_region_application_id =>
3551: G_LOV_RELATION_REDO_TBL(l_index).region_application_id,

Line 3566: AK_REGION2_PVT.UPDATE_LOV_RELATION (

3562: p_base_attribute_code => G_LOV_RELATION_REDO_TBL(l_index).base_attribute_code,
3563: p_direction_flag => G_LOV_RELATION_REDO_TBL(l_index).direction_flag,
3564: p_base_region_appl_id => G_LOV_RELATION_REDO_TBL(l_index).base_region_appl_id,
3565: p_base_region_code => G_LOV_RELATION_REDO_TBL(l_index).base_region_code) then
3566: AK_REGION2_PVT.UPDATE_LOV_RELATION (
3567: p_validation_level => p_validation_level,
3568: p_api_version_number => 1.0,
3569: p_msg_count => l_msg_count,
3570: p_msg_data => l_msg_data,

Line 3593: AK_REGION2_PVT.CREATE_LOV_RELATION (

3589: p_pass => p_pass,
3590: p_copy_redo_flag => l_copy_redo_flag
3591: );
3592: else
3593: AK_REGION2_PVT.CREATE_LOV_RELATION (
3594: p_validation_level => p_validation_level,
3595: p_api_version_number => 1.0,
3596: p_msg_count => l_msg_count,
3597: p_msg_data => l_msg_data,

Line 4626: if AK_REGION2_PVT.GRAPH_COLUMN_EXISTS (

4622:
4623: savepoint start_create_graph_column;
4624:
4625: --** check to see if row already exists **
4626: if AK_REGION2_PVT.GRAPH_COLUMN_EXISTS (
4627: p_api_version_number => 1.0,
4628: p_return_status => l_return_status,
4629: p_region_application_id => p_region_application_id,
4630: p_region_code => p_region_code,

Line 4643: if not AK_REGION2_PVT.VALIDATE_GRAPH_COLUMN (

4639: end if;
4640:
4641: --** validate table columns passed in **
4642: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
4643: if not AK_REGION2_PVT.VALIDATE_GRAPH_COLUMN (
4644: p_validation_level => p_validation_level,
4645: p_api_version_number => 1.0,
4646: p_return_status => l_return_status,
4647: p_region_application_id => p_region_application_id,

Line 4839: if AK_REGION2_PVT.LOV_RELATION_EXISTS (

4835:
4836: savepoint start_create_lov_relation;
4837:
4838: --** check to see if row already exists **
4839: if AK_REGION2_PVT.LOV_RELATION_EXISTS (
4840: p_api_version_number => 1.0,
4841: p_return_status => l_return_status,
4842: p_region_application_id => p_region_application_id,
4843: p_region_code => p_region_code,

Line 4864: if not AK_REGION2_PVT.VALIDATE_LOV_RELATION (

4860: end if;
4861:
4862: --** validate table columns passed in **
4863: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
4864: if not AK_REGION2_PVT.VALIDATE_LOV_RELATION (
4865: p_validation_level => p_validation_level,
4866: p_api_version_number => 1.0,
4867: p_return_status => l_return_status,
4868: p_region_application_id => p_region_application_id,

Line 5143: if not AK_REGION2_PVT.VALIDATE_GRAPH_COLUMN (

5139: close l_get_row_csr;
5140:
5141: --** validate table columns passed in **
5142: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
5143: if not AK_REGION2_PVT.VALIDATE_GRAPH_COLUMN (
5144: p_validation_level => p_validation_level,
5145: p_api_version_number => 1.0,
5146: p_return_status => l_return_status,
5147: p_region_application_id => p_region_application_id,

Line 5380: if not AK_REGION2_PVT.VALIDATE_LOV_RELATION (

5376: close l_get_row_csr;
5377:
5378: --** validate table columns passed in **
5379: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
5380: if not AK_REGION2_PVT.VALIDATE_LOV_RELATION (
5381: p_validation_level => p_validation_level,
5382: p_api_version_number => 1.0,
5383: p_return_status => l_return_status,
5384: p_region_application_id => p_region_application_id,

Line 5883: if AK_REGION2_PVT.CATEGORY_USAGE_EXISTS (

5879:
5880: savepoint start_create_category_usage;
5881:
5882: --** check to see if row already exists **
5883: if AK_REGION2_PVT.CATEGORY_USAGE_EXISTS (
5884: p_api_version_number => 1.0,
5885: p_return_status => l_return_status,
5886: p_region_application_id => p_region_application_id,
5887: p_region_code => p_region_code,

Line 5900: if not AK_REGION2_PVT.VALIDATE_CATEGORY_USAGE (

5896: end if;
5897:
5898: --** validate table columns passed in **
5899: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
5900: if not AK_REGION2_PVT.VALIDATE_CATEGORY_USAGE (
5901: p_validation_level => p_validation_level,
5902: p_api_version_number => 1.0,
5903: p_return_status => l_return_status,
5904: p_region_application_id => p_region_application_id,

Line 6153: if not AK_REGION2_PVT.VALIDATE_CATEGORY_USAGE (

6149: close l_get_row_csr;
6150:
6151: --** validate table columns passed in **
6152: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
6153: if not AK_REGION2_PVT.VALIDATE_CATEGORY_USAGE (
6154: p_validation_level => p_validation_level,
6155: p_api_version_number => 1.0,
6156: p_return_status => l_return_status,
6157: p_region_application_id => p_region_application_id,

Line 6279: end AK_REGION2_PVT;

6275: p_data => p_msg_data);
6276:
6277: end UPDATE_CATEGORY_USAGE;
6278:
6279: end AK_REGION2_PVT;