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_REGION_PVT dependencies on AK_REGION_PVT

Line 1: package body AK_REGION_PVT as

1: package body AK_REGION_PVT as
2: /* $Header: akdvregb.pls 120.6 2006/11/30 23:27:31 tshort ship $ */
3:
4: /*
5: --=======================================================

Line 751: if (NOT AK_REGION_PVT.REGION_EXISTS(

747: if ( (p_nested_region_appl_id <> FND_API.G_MISS_NUM) and
748: (p_nested_region_appl_id is not null) ) or
749: ( (p_nested_region_code <> FND_API.G_MISS_CHAR) and
750: (p_nested_region_code is not null) )then
751: if (NOT AK_REGION_PVT.REGION_EXISTS(
752: p_api_version_number => 1.0,
753: p_return_status => l_return_status,
754: p_region_application_id => p_nested_region_appl_id,
755: p_region_code => p_nested_region_code)) then

Line 770: if (NOT AK_REGION_PVT.REGION_EXISTS(

766: if ( (p_lov_region_application_id <> FND_API.G_MISS_NUM) and
767: (p_lov_region_application_id is not null) ) or
768: ( (p_lov_region_code <> FND_API.G_MISS_CHAR) and
769: (p_lov_region_code is not null) )then
770: if (NOT AK_REGION_PVT.REGION_EXISTS(
771: p_api_version_number => 1.0,
772: p_return_status => l_return_status,
773: p_region_application_id => p_lov_region_application_id,
774: p_region_code => p_lov_region_code)) then

Line 789: if (NOT AK_REGION_PVT.ITEM_EXISTS(

785: if ( (p_lov_attribute_application_id <> FND_API.G_MISS_NUM) and
786: (p_lov_attribute_application_id is not null) ) or
787: ( (p_lov_attribute_code <> FND_API.G_MISS_CHAR) and
788: (p_lov_attribute_code is not null) )then
789: if (NOT AK_REGION_PVT.ITEM_EXISTS(
790: p_api_version_number => 1.0,
791: p_return_status => l_return_status,
792: p_region_application_id => p_lov_region_application_id,
793: p_region_code => p_lov_region_code,

Line 1737: not AK_REGION_PVT.VALIDATE_GRAPH (

1733: fetch l_get_graph_tl_csr into l_graphs_tl_rec;
1734: if l_get_graph_tl_csr%found then
1735: -- write this region graph if it is validated
1736: if (p_validation_level <> FND_API.G_VALID_LEVEL_NONE) and
1737: not AK_REGION_PVT.VALIDATE_GRAPH (
1738: p_validation_level => p_validation_level,
1739: p_api_version_number => 1.0,
1740: p_return_status => l_return_status,
1741: p_region_application_id => l_graphs_rec.region_application_id,

Line 2013: not AK_REGION_PVT.VALIDATE_ITEM (

2009: fetch l_get_item_tl_csr into l_items_tl_rec;
2010: if l_get_item_tl_csr%found then
2011: -- write this region item if it is validated
2012: if (p_validation_level <> FND_API.G_VALID_LEVEL_NONE) and
2013: not AK_REGION_PVT.VALIDATE_ITEM (
2014: p_validation_level => p_validation_level,
2015: p_api_version_number => 1.0,
2016: p_return_status => l_return_status,
2017: p_region_application_id => l_items_rec.region_application_id,

Line 2890: if not AK_REGION_PVT.VALIDATE_REGION (

2886: close l_get_region_tl_csr;
2887:
2888: -- Region must be validated before it is written to the file
2889: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
2890: if not AK_REGION_PVT.VALIDATE_REGION (
2891: p_validation_level => p_validation_level,
2892: p_api_version_number => 1.0,
2893: p_return_status => l_return_status,
2894: p_region_application_id => l_regions_rec.region_application_id,

Line 2919: end if; /* if AK_REGION_PVT.VALIDATE_REGION */

2915: p_region_code);
2916: FND_MSG_PUB.Add;
2917: end if;
2918: raise FND_API.G_EXC_ERROR;
2919: end if; /* if AK_REGION_PVT.VALIDATE_REGION */
2920: end if; /* if p_validation_level */
2921:
2922: -- Write region into buffer
2923: l_index := 1;

Line 3449: if AK_REGION_PVT.GRAPH_EXISTS (

3445:
3446: savepoint start_create_graph;
3447:
3448: --** check to see if row already exists **
3449: if AK_REGION_PVT.GRAPH_EXISTS (
3450: p_api_version_number => 1.0,
3451: p_return_status => l_return_status,
3452: p_region_application_id => p_region_application_id,
3453: p_region_code => p_region_code,

Line 3551: if NOT AK_REGION_PVT.GRAPH_EXISTS (

3547: l_last_update_login
3548: );
3549:
3550: --** row should exists before inserting rows for other languages **
3551: if NOT AK_REGION_PVT.GRAPH_EXISTS (
3552: p_api_version_number => 1.0,
3553: p_return_status => l_return_status,
3554: p_region_application_id => p_region_application_id,
3555: p_region_code => p_region_code,

Line 3890: if AK_REGION_PVT.ITEM_EXISTS (

3886:
3887: /* TSHORT - 5665840 - new logic to avoid unique constraint error */
3888: /* now if we hit that error the exception handling calls update_item */
3889: /* --** check to see if row already exists **
3890: if AK_REGION_PVT.ITEM_EXISTS (
3891: p_api_version_number => 1.0,
3892: p_return_status => l_return_status,
3893: p_region_application_id => p_region_application_id,
3894: p_region_code => p_region_code,

Line 3929: if not AK_REGION_PVT.VALIDATE_ITEM (

3925: end if;
3926:
3927: --** validate table columns passed in **
3928: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
3929: if not AK_REGION_PVT.VALIDATE_ITEM (
3930: p_validation_level => p_validation_level,
3931: p_api_version_number => 1.0,
3932: p_return_status => l_return_status,
3933: p_region_application_id => p_region_application_id,

Line 4539: if NOT AK_REGION_PVT.ITEM_EXISTS (

4535: l_last_update_login
4536: );
4537:
4538: --** row should exists before inserting rows for other languages **
4539: if NOT AK_REGION_PVT.ITEM_EXISTS (
4540: p_api_version_number => 1.0,
4541: p_return_status => l_return_status,
4542: p_region_application_id => p_region_application_id,
4543: p_region_code => p_region_code,

Line 4646: AK_REGION_PVT.UPDATE_ITEM (

4642: p_data => p_msg_data);
4643: WHEN OTHERS THEN
4644: if (SQLCODE = -1) then
4645: rollback to start_create_item;
4646: AK_REGION_PVT.UPDATE_ITEM (
4647: p_validation_level => p_validation_level,
4648: p_api_version_number => 1.0,
4649: p_msg_count => p_msg_count,
4650: p_msg_data => p_msg_data,

Line 4924: if AK_REGION_PVT.REGION_EXISTS (

4920:
4921: savepoint start_create_region;
4922:
4923: --** check to see if row already exists **
4924: if AK_REGION_PVT.REGION_EXISTS (
4925: p_api_version_number => 1.0,
4926: p_return_status => l_return_status,
4927: p_region_application_id => p_region_application_id,
4928: p_region_code => p_region_code) then

Line 4939: if not AK_REGION_PVT.VALIDATE_REGION (

4935: end if;
4936:
4937: --** validate table columns passed in **
4938: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
4939: if not AK_REGION_PVT.VALIDATE_REGION (
4940: p_validation_level => p_validation_level,
4941: p_api_version_number => 1.0,
4942: p_return_status => l_return_status,
4943: p_region_application_id => p_region_application_id,

Line 5304: if NOT AK_REGION_PVT.REGION_EXISTS (

5300: l_last_update_login
5301: );
5302:
5303: --** row should exists before inserting rows for other languages **
5304: if NOT AK_REGION_PVT.REGION_EXISTS (
5305: p_api_version_number => 1.0,
5306: p_return_status => l_return_status,
5307: p_region_application_id => p_region_application_id,
5308: p_region_code => p_region_code) then

Line 5397: AK_REGION_PVT.UPDATE_REGION(

5393: p_data => p_msg_data);
5394: WHEN OTHERS THEN
5395: if (SQLCODE = -1) then
5396: rollback to start_create_region;
5397: AK_REGION_PVT.UPDATE_REGION(
5398: p_validation_level => p_validation_level,
5399: p_api_version_number => 1.0,
5400: p_msg_count => p_msg_count,
5401: p_msg_data => p_msg_data,

Line 5547: if NOT AK_REGION_PVT.GRAPH_EXISTS (

5543:
5544: --
5545: -- error if region item to be deleted does not exists
5546: --
5547: if NOT AK_REGION_PVT.GRAPH_EXISTS (
5548: p_api_version_number => 1.0,
5549: p_return_status => l_return_status,
5550: p_region_application_id => p_region_application_id,
5551: p_region_code => p_region_code,

Line 5788: if NOT AK_REGION_PVT.ITEM_EXISTS (

5784:
5785: --
5786: -- error if region item to be deleted does not exists
5787: --
5788: if NOT AK_REGION_PVT.ITEM_EXISTS (
5789: p_api_version_number => 1.0,
5790: p_return_status => l_return_status,
5791: p_region_application_id => p_region_application_id,
5792: p_region_code => p_region_code,

Line 6095: if NOT AK_REGION_PVT.REGION_EXISTS (

6091: * and do not print out warning message
6092: --
6093: -- error if primary key to be deleted does not exists
6094: --
6095: if NOT AK_REGION_PVT.REGION_EXISTS (
6096: p_api_version_number => 1.0,
6097: p_return_status => l_return_status,
6098: p_region_application_id => p_region_application_id,
6099: p_region_code => p_region_code) then

Line 6108: if AK_REGION_PVT.REGION_EXISTS (

6104: raise FND_API.G_EXC_ERROR;
6105: end if;
6106: **/
6107:
6108: if AK_REGION_PVT.REGION_EXISTS (
6109: p_api_version_number => 1.0,
6110: p_return_status => l_return_status,
6111: p_region_application_id => p_region_application_id,
6112: p_region_code => p_region_code) then

Line 6186: AK_REGION_PVT.DELETE_ITEM (

6182: open l_get_items_csr;
6183: loop
6184: fetch l_get_items_csr into l_attribute_application_id, l_attribute_code;
6185: exit when l_get_items_csr%notfound;
6186: AK_REGION_PVT.DELETE_ITEM (
6187: p_validation_level => p_validation_level,
6188: p_api_version_number => 1.0,
6189: p_msg_count => l_msg_count,
6190: p_msg_data => l_msg_data,

Line 6535: ak_region_pvt.insert_region_pk_table(

6531: -- given list of regions
6532: for l_region_rec in l_get_target_regions_csr (
6533: l_region_pk_tbl(l_index).region_appl_id,
6534: l_region_pk_tbl(l_index).region_code) LOOP
6535: ak_region_pvt.insert_region_pk_table(
6536: p_return_status => l_return_status,
6537: p_region_application_id => l_region_rec.to_region_appl_id,
6538: p_region_code => l_region_rec.to_region_code,
6539: p_region_pk_tbl => l_region_pk_tbl);

Line 6579: AK_REGION_PVT.INSERT_REGION_PK_TABLE (

6575: -- to the list of regions to be downloaded
6576: for l_region_rec in l_get_ri_lov_regions_csr (
6577: l_region_pk_tbl(l_index).region_appl_id,
6578: l_region_pk_tbl(l_index).region_code) LOOP
6579: AK_REGION_PVT.INSERT_REGION_PK_TABLE (
6580: p_return_status => l_return_status,
6581: p_region_application_id =>
6582: l_region_rec.lov_region_application_id,
6583: p_region_code => l_region_rec.lov_region_code,

Line 6592: AK_REGION_PVT.INSERT_REGION_PK_TABLE (

6588: -- referenced by this region to the list of regions to be downloaded
6589: for l_region_rec in l_get_oa_lov_regions_csr (
6590: l_region_pk_tbl(l_index).region_appl_id,
6591: l_region_pk_tbl(l_index).region_code) LOOP
6592: AK_REGION_PVT.INSERT_REGION_PK_TABLE (
6593: p_return_status => l_return_status,
6594: p_region_application_id =>
6595: l_region_rec.lov_region_application_id,
6596: p_region_code => l_region_rec.lov_region_code,

Line 6605: AK_REGION_PVT.INSERT_REGION_PK_TABLE (

6601: -- region item to the list of regions to be downloaded
6602: for l_region_rec in l_get_attr_lov_regions_csr (
6603: l_region_pk_tbl(l_index).region_appl_id,
6604: l_region_pk_tbl(l_index).region_code) LOOP
6605: AK_REGION_PVT.INSERT_REGION_PK_TABLE (
6606: p_return_status => l_return_status,
6607: p_region_application_id =>
6608: l_region_rec.lov_region_application_id,
6609: p_region_code => l_region_rec.lov_region_code,

Line 6621: AK_REGION_PVT.INSERT_REGION_PK_TABLE (

6617: l_region_attr_rec.region_application_id,
6618: l_region_attr_rec.region_code,
6619: l_region_attr_rec.attribute_application_id,
6620: l_region_attr_rec.attribute_code) loop
6621: AK_REGION_PVT.INSERT_REGION_PK_TABLE (
6622: p_return_status => l_return_status,
6623: p_region_application_id =>
6624: l_region_rec.lov_region_appl_id,
6625: p_region_code => l_region_rec.lov_region_code,

Line 6632: AK_REGION_PVT.ADD_NESTED_REG_TO_REG_PK (

6628: end loop;
6629:
6630: -- Add Nested Region used by all region items in this region
6631: -- to the list of regions to be downloaded
6632: AK_REGION_PVT.ADD_NESTED_REG_TO_REG_PK (
6633: p_region_application_id =>
6634: l_region_pk_tbl(l_index).region_appl_id,
6635: p_region_code => l_region_pk_tbl(l_index).region_code,
6636: p_region_pk_tbl => l_region_pk_tbl);

Line 7555: if not AK_REGION_PVT.VALIDATE_ITEM (

7551: --
7552: -- validate table columns passed in
7553: -- ** Note the special processing for object_attribute_flag **
7554: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
7555: if not AK_REGION_PVT.VALIDATE_ITEM (
7556: p_validation_level => p_validation_level,
7557: p_api_version_number => 1.0,
7558: p_return_status => l_return_status,
7559: p_region_application_id => p_region_application_id,

Line 8423: if not AK_REGION_PVT.VALIDATE_REGION (

8419: close l_get_tl_row_csr;
8420:
8421: --** validate table columns passed in **
8422: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
8423: if not AK_REGION_PVT.VALIDATE_REGION (
8424: p_validation_level => p_validation_level,
8425: p_api_version_number => 1.0,
8426: p_return_status => l_return_status,
8427: p_region_application_id => p_region_application_id,

Line 8875: AK_REGION_PVT.ADD_NESTED_REG_TO_REG_PK(

8871: p_region_application_id, p_region_code) loop
8872: for l_non_train_region_rec in l_get_non_train_region_csr(l_region_rec.nested_region_application_id, l_region_rec.nested_region_code) loop
8873: if ( NOT REGION_KEY_EXISTS(l_region_rec.nested_region_application_id, l_region_rec.nested_region_code, p_region_pk_tbl) ) then
8874: -- drilling into the nested levels
8875: AK_REGION_PVT.ADD_NESTED_REG_TO_REG_PK(
8876: l_region_rec.nested_region_application_id,
8877: l_region_rec.nested_region_code,
8878: p_region_pk_tbl);
8879: end if;

Line 8881: AK_REGION_PVT.INSERT_REGION_PK_TABLE (

8877: l_region_rec.nested_region_code,
8878: p_region_pk_tbl);
8879: end if;
8880: end loop; -- end l_get_non_train_region_csr
8881: AK_REGION_PVT.INSERT_REGION_PK_TABLE (
8882: p_return_status => l_return_status,
8883: p_region_application_id =>
8884: l_region_rec.nested_region_application_id,
8885: p_region_code => l_region_rec.nested_region_code,

Line 8892: end AK_REGION_PVT;

8888:
8889: end ADD_NESTED_REG_TO_REG_PK;
8890:
8891:
8892: end AK_REGION_PVT;