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.12020000.2 2012/11/20 19:18:23 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 4542: if NOT AK_REGION_PVT.ITEM_EXISTS (

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

Line 4652: AK_REGION_PVT.UPDATE_ITEM (

4648: p_data => p_msg_data);
4649: WHEN OTHERS THEN
4650: if (SQLCODE = -1) then
4651: rollback to start_create_item;
4652: AK_REGION_PVT.UPDATE_ITEM (
4653: p_validation_level => p_validation_level,
4654: p_api_version_number => 1.0,
4655: p_msg_count => p_msg_count,
4656: p_msg_data => p_msg_data,

Line 4930: if AK_REGION_PVT.REGION_EXISTS (

4926:
4927: savepoint start_create_region;
4928:
4929: --** check to see if row already exists **
4930: if AK_REGION_PVT.REGION_EXISTS (
4931: p_api_version_number => 1.0,
4932: p_return_status => l_return_status,
4933: p_region_application_id => p_region_application_id,
4934: p_region_code => p_region_code) then

Line 4945: if not AK_REGION_PVT.VALIDATE_REGION (

4941: end if;
4942:
4943: --** validate table columns passed in **
4944: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
4945: if not AK_REGION_PVT.VALIDATE_REGION (
4946: p_validation_level => p_validation_level,
4947: p_api_version_number => 1.0,
4948: p_return_status => l_return_status,
4949: p_region_application_id => p_region_application_id,

Line 5313: if NOT AK_REGION_PVT.REGION_EXISTS (

5309: l_last_update_login
5310: );
5311:
5312: --** row should exists before inserting rows for other languages **
5313: if NOT AK_REGION_PVT.REGION_EXISTS (
5314: p_api_version_number => 1.0,
5315: p_return_status => l_return_status,
5316: p_region_application_id => p_region_application_id,
5317: p_region_code => p_region_code) then

Line 5408: AK_REGION_PVT.UPDATE_REGION(

5404: p_data => p_msg_data);
5405: WHEN OTHERS THEN
5406: if (SQLCODE = -1) then
5407: rollback to start_create_region;
5408: AK_REGION_PVT.UPDATE_REGION(
5409: p_validation_level => p_validation_level,
5410: p_api_version_number => 1.0,
5411: p_msg_count => p_msg_count,
5412: p_msg_data => p_msg_data,

Line 5558: if NOT AK_REGION_PVT.GRAPH_EXISTS (

5554:
5555: --
5556: -- error if region item to be deleted does not exists
5557: --
5558: if NOT AK_REGION_PVT.GRAPH_EXISTS (
5559: p_api_version_number => 1.0,
5560: p_return_status => l_return_status,
5561: p_region_application_id => p_region_application_id,
5562: p_region_code => p_region_code,

Line 5799: if NOT AK_REGION_PVT.ITEM_EXISTS (

5795:
5796: --
5797: -- error if region item to be deleted does not exists
5798: --
5799: if NOT AK_REGION_PVT.ITEM_EXISTS (
5800: p_api_version_number => 1.0,
5801: p_return_status => l_return_status,
5802: p_region_application_id => p_region_application_id,
5803: p_region_code => p_region_code,

Line 6106: if NOT AK_REGION_PVT.REGION_EXISTS (

6102: * and do not print out warning message
6103: --
6104: -- error if primary key to be deleted does not exists
6105: --
6106: if NOT AK_REGION_PVT.REGION_EXISTS (
6107: p_api_version_number => 1.0,
6108: p_return_status => l_return_status,
6109: p_region_application_id => p_region_application_id,
6110: p_region_code => p_region_code) then

Line 6119: if AK_REGION_PVT.REGION_EXISTS (

6115: raise FND_API.G_EXC_ERROR;
6116: end if;
6117: **/
6118:
6119: if AK_REGION_PVT.REGION_EXISTS (
6120: p_api_version_number => 1.0,
6121: p_return_status => l_return_status,
6122: p_region_application_id => p_region_application_id,
6123: p_region_code => p_region_code) then

Line 6197: AK_REGION_PVT.DELETE_ITEM (

6193: open l_get_items_csr;
6194: loop
6195: fetch l_get_items_csr into l_attribute_application_id, l_attribute_code;
6196: exit when l_get_items_csr%notfound;
6197: AK_REGION_PVT.DELETE_ITEM (
6198: p_validation_level => p_validation_level,
6199: p_api_version_number => 1.0,
6200: p_msg_count => l_msg_count,
6201: p_msg_data => l_msg_data,

Line 6546: ak_region_pvt.insert_region_pk_table(

6542: -- given list of regions
6543: for l_region_rec in l_get_target_regions_csr (
6544: l_region_pk_tbl(l_index).region_appl_id,
6545: l_region_pk_tbl(l_index).region_code) LOOP
6546: ak_region_pvt.insert_region_pk_table(
6547: p_return_status => l_return_status,
6548: p_region_application_id => l_region_rec.to_region_appl_id,
6549: p_region_code => l_region_rec.to_region_code,
6550: p_region_pk_tbl => l_region_pk_tbl);

Line 6590: AK_REGION_PVT.INSERT_REGION_PK_TABLE (

6586: -- to the list of regions to be downloaded
6587: for l_region_rec in l_get_ri_lov_regions_csr (
6588: l_region_pk_tbl(l_index).region_appl_id,
6589: l_region_pk_tbl(l_index).region_code) LOOP
6590: AK_REGION_PVT.INSERT_REGION_PK_TABLE (
6591: p_return_status => l_return_status,
6592: p_region_application_id =>
6593: l_region_rec.lov_region_application_id,
6594: p_region_code => l_region_rec.lov_region_code,

Line 6603: AK_REGION_PVT.INSERT_REGION_PK_TABLE (

6599: -- referenced by this region to the list of regions to be downloaded
6600: for l_region_rec in l_get_oa_lov_regions_csr (
6601: l_region_pk_tbl(l_index).region_appl_id,
6602: l_region_pk_tbl(l_index).region_code) LOOP
6603: AK_REGION_PVT.INSERT_REGION_PK_TABLE (
6604: p_return_status => l_return_status,
6605: p_region_application_id =>
6606: l_region_rec.lov_region_application_id,
6607: p_region_code => l_region_rec.lov_region_code,

Line 6616: AK_REGION_PVT.INSERT_REGION_PK_TABLE (

6612: -- region item to the list of regions to be downloaded
6613: for l_region_rec in l_get_attr_lov_regions_csr (
6614: l_region_pk_tbl(l_index).region_appl_id,
6615: l_region_pk_tbl(l_index).region_code) LOOP
6616: AK_REGION_PVT.INSERT_REGION_PK_TABLE (
6617: p_return_status => l_return_status,
6618: p_region_application_id =>
6619: l_region_rec.lov_region_application_id,
6620: p_region_code => l_region_rec.lov_region_code,

Line 6632: AK_REGION_PVT.INSERT_REGION_PK_TABLE (

6628: l_region_attr_rec.region_application_id,
6629: l_region_attr_rec.region_code,
6630: l_region_attr_rec.attribute_application_id,
6631: l_region_attr_rec.attribute_code) loop
6632: AK_REGION_PVT.INSERT_REGION_PK_TABLE (
6633: p_return_status => l_return_status,
6634: p_region_application_id =>
6635: l_region_rec.lov_region_appl_id,
6636: p_region_code => l_region_rec.lov_region_code,

Line 6643: AK_REGION_PVT.ADD_NESTED_REG_TO_REG_PK (

6639: end loop;
6640:
6641: -- Add Nested Region used by all region items in this region
6642: -- to the list of regions to be downloaded
6643: AK_REGION_PVT.ADD_NESTED_REG_TO_REG_PK (
6644: p_region_application_id =>
6645: l_region_pk_tbl(l_index).region_appl_id,
6646: p_region_code => l_region_pk_tbl(l_index).region_code,
6647: p_region_pk_tbl => l_region_pk_tbl);

Line 7566: if not AK_REGION_PVT.VALIDATE_ITEM (

7562: --
7563: -- validate table columns passed in
7564: -- ** Note the special processing for object_attribute_flag **
7565: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
7566: if not AK_REGION_PVT.VALIDATE_ITEM (
7567: p_validation_level => p_validation_level,
7568: p_api_version_number => 1.0,
7569: p_return_status => l_return_status,
7570: p_region_application_id => p_region_application_id,

Line 8440: if not AK_REGION_PVT.VALIDATE_REGION (

8436: close l_get_tl_row_csr;
8437:
8438: --** validate table columns passed in **
8439: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
8440: if not AK_REGION_PVT.VALIDATE_REGION (
8441: p_validation_level => p_validation_level,
8442: p_api_version_number => 1.0,
8443: p_return_status => l_return_status,
8444: p_region_application_id => p_region_application_id,

Line 8898: AK_REGION_PVT.ADD_NESTED_REG_TO_REG_PK(

8894: p_region_application_id, p_region_code) loop
8895: 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
8896: if ( NOT REGION_KEY_EXISTS(l_region_rec.nested_region_application_id, l_region_rec.nested_region_code, p_region_pk_tbl) ) then
8897: -- drilling into the nested levels
8898: AK_REGION_PVT.ADD_NESTED_REG_TO_REG_PK(
8899: l_region_rec.nested_region_application_id,
8900: l_region_rec.nested_region_code,
8901: p_region_pk_tbl);
8902: end if;

Line 8904: AK_REGION_PVT.INSERT_REGION_PK_TABLE (

8900: l_region_rec.nested_region_code,
8901: p_region_pk_tbl);
8902: end if;
8903: end loop; -- end l_get_non_train_region_csr
8904: AK_REGION_PVT.INSERT_REGION_PK_TABLE (
8905: p_return_status => l_return_status,
8906: p_region_application_id =>
8907: l_region_rec.nested_region_application_id,
8908: p_region_code => l_region_rec.nested_region_code,

Line 8915: end AK_REGION_PVT;

8911:
8912: end ADD_NESTED_REG_TO_REG_PK;
8913:
8914:
8915: end AK_REGION_PVT;