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.12020000.2 2012/11/20 19:12:16 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 3551: if AK_REGION2_PVT.LOV_RELATION_EXISTS (

3547: if ( G_LOV_RELATION_REDO_TBL(l_index).base_region_code is null ) then
3548: G_LOV_RELATION_REDO_TBL(l_index).base_region_code := G_LOV_RELATION_REDO_TBL(l_index).region_code;
3549: end if;
3550:
3551: if AK_REGION2_PVT.LOV_RELATION_EXISTS (
3552: p_api_version_number => 1.0,
3553: p_return_status => l_return_status,
3554: p_region_application_id =>
3555: G_LOV_RELATION_REDO_TBL(l_index).region_application_id,

Line 3570: AK_REGION2_PVT.UPDATE_LOV_RELATION (

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

Line 3597: AK_REGION2_PVT.CREATE_LOV_RELATION (

3593: p_pass => p_pass,
3594: p_copy_redo_flag => l_copy_redo_flag
3595: );
3596: else
3597: AK_REGION2_PVT.CREATE_LOV_RELATION (
3598: p_validation_level => p_validation_level,
3599: p_api_version_number => 1.0,
3600: p_msg_count => l_msg_count,
3601: p_msg_data => l_msg_data,

Line 4643: if AK_REGION2_PVT.GRAPH_COLUMN_EXISTS (

4639:
4640: savepoint start_create_graph_column;
4641:
4642: --** check to see if row already exists **
4643: if AK_REGION2_PVT.GRAPH_COLUMN_EXISTS (
4644: p_api_version_number => 1.0,
4645: p_return_status => l_return_status,
4646: p_region_application_id => p_region_application_id,
4647: p_region_code => p_region_code,

Line 4660: if not AK_REGION2_PVT.VALIDATE_GRAPH_COLUMN (

4656: end if;
4657:
4658: --** validate table columns passed in **
4659: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
4660: if not AK_REGION2_PVT.VALIDATE_GRAPH_COLUMN (
4661: p_validation_level => p_validation_level,
4662: p_api_version_number => 1.0,
4663: p_return_status => l_return_status,
4664: p_region_application_id => p_region_application_id,

Line 4856: if AK_REGION2_PVT.LOV_RELATION_EXISTS (

4852:
4853: savepoint start_create_lov_relation;
4854:
4855: --** check to see if row already exists **
4856: if AK_REGION2_PVT.LOV_RELATION_EXISTS (
4857: p_api_version_number => 1.0,
4858: p_return_status => l_return_status,
4859: p_region_application_id => p_region_application_id,
4860: p_region_code => p_region_code,

Line 4881: if not AK_REGION2_PVT.VALIDATE_LOV_RELATION (

4877: end if;
4878:
4879: --** validate table columns passed in **
4880: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
4881: if not AK_REGION2_PVT.VALIDATE_LOV_RELATION (
4882: p_validation_level => p_validation_level,
4883: p_api_version_number => 1.0,
4884: p_return_status => l_return_status,
4885: p_region_application_id => p_region_application_id,

Line 5165: if not AK_REGION2_PVT.VALIDATE_GRAPH_COLUMN (

5161: close l_get_row_csr;
5162:
5163: --** validate table columns passed in **
5164: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
5165: if not AK_REGION2_PVT.VALIDATE_GRAPH_COLUMN (
5166: p_validation_level => p_validation_level,
5167: p_api_version_number => 1.0,
5168: p_return_status => l_return_status,
5169: p_region_application_id => p_region_application_id,

Line 5402: if not AK_REGION2_PVT.VALIDATE_LOV_RELATION (

5398: close l_get_row_csr;
5399:
5400: --** validate table columns passed in **
5401: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
5402: if not AK_REGION2_PVT.VALIDATE_LOV_RELATION (
5403: p_validation_level => p_validation_level,
5404: p_api_version_number => 1.0,
5405: p_return_status => l_return_status,
5406: p_region_application_id => p_region_application_id,

Line 5911: if AK_REGION2_PVT.CATEGORY_USAGE_EXISTS (

5907:
5908: savepoint start_create_category_usage;
5909:
5910: --** check to see if row already exists **
5911: if AK_REGION2_PVT.CATEGORY_USAGE_EXISTS (
5912: p_api_version_number => 1.0,
5913: p_return_status => l_return_status,
5914: p_region_application_id => p_region_application_id,
5915: p_region_code => p_region_code,

Line 5928: if not AK_REGION2_PVT.VALIDATE_CATEGORY_USAGE (

5924: end if;
5925:
5926: --** validate table columns passed in **
5927: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
5928: if not AK_REGION2_PVT.VALIDATE_CATEGORY_USAGE (
5929: p_validation_level => p_validation_level,
5930: p_api_version_number => 1.0,
5931: p_return_status => l_return_status,
5932: p_region_application_id => p_region_application_id,

Line 6186: if not AK_REGION2_PVT.VALIDATE_CATEGORY_USAGE (

6182: close l_get_row_csr;
6183:
6184: --** validate table columns passed in **
6185: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
6186: if not AK_REGION2_PVT.VALIDATE_CATEGORY_USAGE (
6187: p_validation_level => p_validation_level,
6188: p_api_version_number => 1.0,
6189: p_return_status => l_return_status,
6190: p_region_application_id => p_region_application_id,

Line 6317: end AK_REGION2_PVT;

6313: p_data => p_msg_data);
6314:
6315: end UPDATE_CATEGORY_USAGE;
6316:
6317: end AK_REGION2_PVT;