DBA Data[Home] [Help]

APPS.AK_OBJECT_PVT dependencies on AK_OBJECT_PVT

Line 1: package body AK_OBJECT_PVT as

1: package body AK_OBJECT_PVT as
2: /* $Header: akdvobjb.pls 120.3.12020000.2 2012/12/03 22:01:01 tshort ship $ */
3:
4: --=======================================================
5: -- Function VALID_TO_REGION (local)

Line 365: if (NOT AK_OBJECT_PVT.OBJECT_EXISTS (

361: --* procedure has retrieved the parent object before retrieving its
362: --* object attributes.)
363:
364: if (p_caller <> AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
365: if (NOT AK_OBJECT_PVT.OBJECT_EXISTS (
366: p_api_version_number => 1.0,
367: p_return_status => l_return_status,
368: p_database_object_name => p_database_object_name)) then
369: l_error := TRUE;

Line 653: if (NOT AK_OBJECT_PVT.VALID_COLUMN_NAME (

649: end if;
650:
651: -- - column name
652: if (p_column_name <> FND_API.G_MISS_CHAR) then
653: if (NOT AK_OBJECT_PVT.VALID_COLUMN_NAME (
654: p_table_name => p_database_object_name,
655: p_column_name => p_column_name) ) then
656: if ( AK_ON_OBJECTS_PUB.G_LOAD_MODE = 'DOWNLOAD' or p_pass = 1 ) then
657: l_error := TRUE;

Line 1429: AK_OBJECT_PVT.INSERT_OBJECT_PK_TABLE (

1425: end if;
1426:
1427: for l_from_index in p_from_table.FIRST .. p_from_table.LAST LOOP
1428: if (p_from_table.EXISTS(l_from_index)) then
1429: AK_OBJECT_PVT.INSERT_OBJECT_PK_TABLE (
1430: p_return_status => l_return_status,
1431: p_database_object_name => p_from_table(l_from_index),
1432: p_object_pk_tbl => p_to_table);
1433: if (l_return_status = FND_API.G_RET_STS_ERROR) or

Line 2052: if NOT AK_OBJECT_PVT.ATTRIBUTE_EXISTS (

2048:
2049: --
2050: -- error if object attribute to be deleted does not exists
2051: --
2052: if NOT AK_OBJECT_PVT.ATTRIBUTE_EXISTS (
2053: p_api_version_number => 1.0,
2054: p_return_status => l_return_status,
2055: p_database_object_name => p_database_object_name,
2056: p_attribute_application_id => p_attribute_application_id,

Line 2147: AK_OBJECT_PVT.DELETE_ATTRIBUTE_NAVIGATION (

2143: loop
2144: fetch l_get_navigations_csr into l_value_varchar2, l_value_date,
2145: l_value_number;
2146: exit when l_get_navigations_csr%notfound;
2147: AK_OBJECT_PVT.DELETE_ATTRIBUTE_NAVIGATION (
2148: p_validation_level => p_validation_level,
2149: p_api_version_number => 1.0,
2150: p_msg_count => l_msg_count,
2151: p_msg_data => l_msg_data,

Line 2177: AK_OBJECT_PVT.DELETE_ATTRIBUTE_VALUE (

2173: fetch l_get_attr_values_csr into
2174: l_key_value1, l_key_value2, l_key_value3, l_key_value4, l_key_value5,
2175: l_key_value6, l_key_value7, l_key_value8, l_key_value9, l_key_value10;
2176: exit when l_get_attr_values_csr%notfound;
2177: AK_OBJECT_PVT.DELETE_ATTRIBUTE_VALUE (
2178: p_validation_level => p_validation_level,
2179: p_api_version_number => 1.0,
2180: p_msg_count => l_msg_count,
2181: p_msg_data => l_msg_data,

Line 2409: if NOT AK_OBJECT_PVT.ATTRIBUTE_NAVIGATION_EXISTS (

2405:
2406: --
2407: -- error if object attribute navigation record to be deleted does not exists
2408: --
2409: if NOT AK_OBJECT_PVT.ATTRIBUTE_NAVIGATION_EXISTS (
2410: p_api_version_number => 1.0,
2411: p_return_status => l_return_status,
2412: p_database_object_name => p_database_object_name,
2413: p_attribute_application_id => p_attribute_application_id,

Line 2649: if NOT AK_OBJECT_PVT.ATTRIBUTE_VALUE_EXISTS (

2645:
2646: --
2647: -- error if attribute value record to be deleted does not exists
2648: --
2649: if NOT AK_OBJECT_PVT.ATTRIBUTE_VALUE_EXISTS (
2650: p_api_version_number => 1.0,
2651: p_return_status => l_return_status,
2652: p_database_object_name => p_database_object_name,
2653: p_attribute_application_id => p_attribute_application_id,

Line 2942: if NOT AK_OBJECT_PVT.OBJECT_EXISTS (

2938:
2939: --
2940: -- error if object to be deleted does not exists
2941: --
2942: if NOT AK_OBJECT_PVT.OBJECT_EXISTS (
2943: p_api_version_number => 1.0,
2944: p_return_status => l_return_status,
2945: p_database_object_name => p_database_object_name) then
2946: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 3029: AK_OBJECT_PVT.DELETE_ATTRIBUTE (

3025: loop
3026: fetch l_get_obj_attributes_csr into
3027: l_attribute_application_id, l_attribute_code;
3028: exit when l_get_obj_attributes_csr%notfound;
3029: AK_OBJECT_PVT.DELETE_ATTRIBUTE (
3030: p_validation_level => p_validation_level,
3031: p_api_version_number => 1.0,
3032: p_msg_count => l_msg_count,
3033: p_msg_data => l_msg_data,

Line 3354: if (AK_OBJECT_PVT.OBJECT_EXISTS (

3350:
3351: savepoint start_create_object;
3352:
3353: --** check to see if row already exists **
3354: if (AK_OBJECT_PVT.OBJECT_EXISTS (
3355: p_api_version_number => 1.0,
3356: p_return_status => l_return_status,
3357: p_database_object_name => p_database_object_name)) then
3358: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 3368: if not AK_OBJECT_PVT.VALIDATE_OBJECT(

3364: end if;
3365:
3366: --** validate table columns passed in **
3367: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
3368: if not AK_OBJECT_PVT.VALIDATE_OBJECT(
3369: p_validation_level => p_validation_level,
3370: p_api_version_number => 1.0,
3371: p_return_status => l_return_status,
3372: p_database_object_name => p_database_object_name,

Line 3590: if (NOT AK_OBJECT_PVT.OBJECT_EXISTS (

3586: -- /** commit the insert **/
3587: -- commit;
3588:
3589: --** row should exists before inserting rows for other languages **
3590: if (NOT AK_OBJECT_PVT.OBJECT_EXISTS (
3591: p_api_version_number => 1.0,
3592: p_return_status => l_return_status,
3593: p_database_object_name => p_database_object_name)) then
3594: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 3824: if (AK_OBJECT_PVT.ATTRIBUTE_EXISTS (

3820:
3821: savepoint start_create_attribute;
3822:
3823: --** check to see if row already exists **
3824: if (AK_OBJECT_PVT.ATTRIBUTE_EXISTS (
3825: p_api_version_number => 1.0,
3826: p_return_status => l_return_status,
3827: p_database_object_name => p_database_object_name,
3828: p_attribute_application_id => p_attribute_application_id,

Line 3862: if not AK_OBJECT_PVT.VALIDATE_ATTRIBUTE (

3858: end if;
3859:
3860: --** validate table columns passed in **
3861: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
3862: if not AK_OBJECT_PVT.VALIDATE_ATTRIBUTE (
3863: p_validation_level => p_validation_level,
3864: p_api_version_number => 1.0,
3865: p_return_status => l_return_status,
3866: p_database_object_name => p_database_object_name,

Line 4182: if (NOT AK_OBJECT_PVT.ATTRIBUTE_EXISTS (

4178: l_last_update_login
4179: );
4180:
4181: --** row should exists before inserting rows for other languages **
4182: if (NOT AK_OBJECT_PVT.ATTRIBUTE_EXISTS (
4183: p_api_version_number => 1.0,
4184: p_return_status => l_return_status,
4185: p_database_object_name => p_database_object_name,
4186: p_attribute_application_id => p_attribute_application_id,

Line 4422: if AK_OBJECT_PVT.ATTRIBUTE_NAVIGATION_EXISTS (

4418: raise FND_API.G_EXC_ERROR;
4419: end if;
4420:
4421: --** check to see if row already exists **
4422: if AK_OBJECT_PVT.ATTRIBUTE_NAVIGATION_EXISTS (
4423: p_api_version_number => 1.0,
4424: p_return_status => l_return_status,
4425: p_database_object_name => p_database_object_name,
4426: p_attribute_application_id => p_attribute_application_id,

Line 4440: if not AK_OBJECT_PVT.VALIDATE_ATTRIBUTE_NAVIGATION (

4436: end if;
4437:
4438: --** validate table columns passed in **
4439: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
4440: if not AK_OBJECT_PVT.VALIDATE_ATTRIBUTE_NAVIGATION (
4441: p_validation_level => p_validation_level,
4442: p_api_version_number => 1.0,
4443: p_return_status => l_return_status,
4444: p_database_object_name => p_database_object_name,

Line 4788: if AK_OBJECT_PVT.ATTRIBUTE_VALUE_EXISTS (

4784:
4785: savepoint start_create_value;
4786:
4787: --** check to see if row already exists **
4788: if AK_OBJECT_PVT.ATTRIBUTE_VALUE_EXISTS (
4789: p_api_version_number => 1.0,
4790: p_return_status => l_return_status,
4791: p_database_object_name => p_database_object_name,
4792: p_attribute_application_id => p_attribute_application_id,

Line 4816: if not AK_OBJECT_PVT.VALIDATE_ATTRIBUTE_VALUE (

4812: end if;
4813:
4814: --** validate table columns passed in **
4815: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
4816: if not AK_OBJECT_PVT.VALIDATE_ATTRIBUTE_VALUE (
4817: p_validation_level => p_validation_level,
4818: p_api_version_number => 1.0,
4819: p_return_status => l_return_status,
4820: p_database_object_name => p_database_object_name,

Line 5064: end AK_OBJECT_PVT;

5060: p_count => p_msg_count,
5061: p_data => p_msg_data);
5062: end CREATE_ATTRIBUTE_VALUE;
5063:
5064: end AK_OBJECT_PVT;