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 2005/09/26 20:14:34 tshort ship $ */
3:
4: --=======================================================
5: -- Function VALID_TO_REGION (local)

Line 358: if (NOT AK_OBJECT_PVT.OBJECT_EXISTS (

354: --* procedure has retrieved the parent object before retrieving its
355: --* object attributes.)
356:
357: if (p_caller <> AK_ON_OBJECTS_PVT.G_DOWNLOAD) then
358: if (NOT AK_OBJECT_PVT.OBJECT_EXISTS (
359: p_api_version_number => 1.0,
360: p_return_status => l_return_status,
361: p_database_object_name => p_database_object_name)) then
362: l_error := TRUE;

Line 646: if (NOT AK_OBJECT_PVT.VALID_COLUMN_NAME (

642: end if;
643:
644: -- - column name
645: if (p_column_name <> FND_API.G_MISS_CHAR) then
646: if (NOT AK_OBJECT_PVT.VALID_COLUMN_NAME (
647: p_table_name => p_database_object_name,
648: p_column_name => p_column_name) ) then
649: if ( AK_ON_OBJECTS_PUB.G_LOAD_MODE = 'DOWNLOAD' or p_pass = 1 ) then
650: l_error := TRUE;

Line 1422: AK_OBJECT_PVT.INSERT_OBJECT_PK_TABLE (

1418: end if;
1419:
1420: for l_from_index in p_from_table.FIRST .. p_from_table.LAST LOOP
1421: if (p_from_table.EXISTS(l_from_index)) then
1422: AK_OBJECT_PVT.INSERT_OBJECT_PK_TABLE (
1423: p_return_status => l_return_status,
1424: p_database_object_name => p_from_table(l_from_index),
1425: p_object_pk_tbl => p_to_table);
1426: if (l_return_status = FND_API.G_RET_STS_ERROR) or

Line 2045: if NOT AK_OBJECT_PVT.ATTRIBUTE_EXISTS (

2041:
2042: --
2043: -- error if object attribute to be deleted does not exists
2044: --
2045: if NOT AK_OBJECT_PVT.ATTRIBUTE_EXISTS (
2046: p_api_version_number => 1.0,
2047: p_return_status => l_return_status,
2048: p_database_object_name => p_database_object_name,
2049: p_attribute_application_id => p_attribute_application_id,

Line 2140: AK_OBJECT_PVT.DELETE_ATTRIBUTE_NAVIGATION (

2136: loop
2137: fetch l_get_navigations_csr into l_value_varchar2, l_value_date,
2138: l_value_number;
2139: exit when l_get_navigations_csr%notfound;
2140: AK_OBJECT_PVT.DELETE_ATTRIBUTE_NAVIGATION (
2141: p_validation_level => p_validation_level,
2142: p_api_version_number => 1.0,
2143: p_msg_count => l_msg_count,
2144: p_msg_data => l_msg_data,

Line 2170: AK_OBJECT_PVT.DELETE_ATTRIBUTE_VALUE (

2166: fetch l_get_attr_values_csr into
2167: l_key_value1, l_key_value2, l_key_value3, l_key_value4, l_key_value5,
2168: l_key_value6, l_key_value7, l_key_value8, l_key_value9, l_key_value10;
2169: exit when l_get_attr_values_csr%notfound;
2170: AK_OBJECT_PVT.DELETE_ATTRIBUTE_VALUE (
2171: p_validation_level => p_validation_level,
2172: p_api_version_number => 1.0,
2173: p_msg_count => l_msg_count,
2174: p_msg_data => l_msg_data,

Line 2402: if NOT AK_OBJECT_PVT.ATTRIBUTE_NAVIGATION_EXISTS (

2398:
2399: --
2400: -- error if object attribute navigation record to be deleted does not exists
2401: --
2402: if NOT AK_OBJECT_PVT.ATTRIBUTE_NAVIGATION_EXISTS (
2403: p_api_version_number => 1.0,
2404: p_return_status => l_return_status,
2405: p_database_object_name => p_database_object_name,
2406: p_attribute_application_id => p_attribute_application_id,

Line 2642: if NOT AK_OBJECT_PVT.ATTRIBUTE_VALUE_EXISTS (

2638:
2639: --
2640: -- error if attribute value record to be deleted does not exists
2641: --
2642: if NOT AK_OBJECT_PVT.ATTRIBUTE_VALUE_EXISTS (
2643: p_api_version_number => 1.0,
2644: p_return_status => l_return_status,
2645: p_database_object_name => p_database_object_name,
2646: p_attribute_application_id => p_attribute_application_id,

Line 2935: if NOT AK_OBJECT_PVT.OBJECT_EXISTS (

2931:
2932: --
2933: -- error if object to be deleted does not exists
2934: --
2935: if NOT AK_OBJECT_PVT.OBJECT_EXISTS (
2936: p_api_version_number => 1.0,
2937: p_return_status => l_return_status,
2938: p_database_object_name => p_database_object_name) then
2939: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 3022: AK_OBJECT_PVT.DELETE_ATTRIBUTE (

3018: loop
3019: fetch l_get_obj_attributes_csr into
3020: l_attribute_application_id, l_attribute_code;
3021: exit when l_get_obj_attributes_csr%notfound;
3022: AK_OBJECT_PVT.DELETE_ATTRIBUTE (
3023: p_validation_level => p_validation_level,
3024: p_api_version_number => 1.0,
3025: p_msg_count => l_msg_count,
3026: p_msg_data => l_msg_data,

Line 3347: if (AK_OBJECT_PVT.OBJECT_EXISTS (

3343:
3344: savepoint start_create_object;
3345:
3346: --** check to see if row already exists **
3347: if (AK_OBJECT_PVT.OBJECT_EXISTS (
3348: p_api_version_number => 1.0,
3349: p_return_status => l_return_status,
3350: p_database_object_name => p_database_object_name)) then
3351: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 3361: if not AK_OBJECT_PVT.VALIDATE_OBJECT(

3357: end if;
3358:
3359: --** validate table columns passed in **
3360: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
3361: if not AK_OBJECT_PVT.VALIDATE_OBJECT(
3362: p_validation_level => p_validation_level,
3363: p_api_version_number => 1.0,
3364: p_return_status => l_return_status,
3365: p_database_object_name => p_database_object_name,

Line 3583: if (NOT AK_OBJECT_PVT.OBJECT_EXISTS (

3579: -- /** commit the insert **/
3580: -- commit;
3581:
3582: --** row should exists before inserting rows for other languages **
3583: if (NOT AK_OBJECT_PVT.OBJECT_EXISTS (
3584: p_api_version_number => 1.0,
3585: p_return_status => l_return_status,
3586: p_database_object_name => p_database_object_name)) then
3587: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 3817: if (AK_OBJECT_PVT.ATTRIBUTE_EXISTS (

3813:
3814: savepoint start_create_attribute;
3815:
3816: --** check to see if row already exists **
3817: if (AK_OBJECT_PVT.ATTRIBUTE_EXISTS (
3818: p_api_version_number => 1.0,
3819: p_return_status => l_return_status,
3820: p_database_object_name => p_database_object_name,
3821: p_attribute_application_id => p_attribute_application_id,

Line 3855: if not AK_OBJECT_PVT.VALIDATE_ATTRIBUTE (

3851: end if;
3852:
3853: --** validate table columns passed in **
3854: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
3855: if not AK_OBJECT_PVT.VALIDATE_ATTRIBUTE (
3856: p_validation_level => p_validation_level,
3857: p_api_version_number => 1.0,
3858: p_return_status => l_return_status,
3859: p_database_object_name => p_database_object_name,

Line 4175: if (NOT AK_OBJECT_PVT.ATTRIBUTE_EXISTS (

4171: l_last_update_login
4172: );
4173:
4174: --** row should exists before inserting rows for other languages **
4175: if (NOT AK_OBJECT_PVT.ATTRIBUTE_EXISTS (
4176: p_api_version_number => 1.0,
4177: p_return_status => l_return_status,
4178: p_database_object_name => p_database_object_name,
4179: p_attribute_application_id => p_attribute_application_id,

Line 4415: if AK_OBJECT_PVT.ATTRIBUTE_NAVIGATION_EXISTS (

4411: raise FND_API.G_EXC_ERROR;
4412: end if;
4413:
4414: --** check to see if row already exists **
4415: if AK_OBJECT_PVT.ATTRIBUTE_NAVIGATION_EXISTS (
4416: p_api_version_number => 1.0,
4417: p_return_status => l_return_status,
4418: p_database_object_name => p_database_object_name,
4419: p_attribute_application_id => p_attribute_application_id,

Line 4433: if not AK_OBJECT_PVT.VALIDATE_ATTRIBUTE_NAVIGATION (

4429: end if;
4430:
4431: --** validate table columns passed in **
4432: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
4433: if not AK_OBJECT_PVT.VALIDATE_ATTRIBUTE_NAVIGATION (
4434: p_validation_level => p_validation_level,
4435: p_api_version_number => 1.0,
4436: p_return_status => l_return_status,
4437: p_database_object_name => p_database_object_name,

Line 4781: if AK_OBJECT_PVT.ATTRIBUTE_VALUE_EXISTS (

4777:
4778: savepoint start_create_value;
4779:
4780: --** check to see if row already exists **
4781: if AK_OBJECT_PVT.ATTRIBUTE_VALUE_EXISTS (
4782: p_api_version_number => 1.0,
4783: p_return_status => l_return_status,
4784: p_database_object_name => p_database_object_name,
4785: p_attribute_application_id => p_attribute_application_id,

Line 4809: if not AK_OBJECT_PVT.VALIDATE_ATTRIBUTE_VALUE (

4805: end if;
4806:
4807: --** validate table columns passed in **
4808: if p_validation_level <> FND_API.G_VALID_LEVEL_NONE then
4809: if not AK_OBJECT_PVT.VALIDATE_ATTRIBUTE_VALUE (
4810: p_validation_level => p_validation_level,
4811: p_api_version_number => 1.0,
4812: p_return_status => l_return_status,
4813: p_database_object_name => p_database_object_name,

Line 5057: end AK_OBJECT_PVT;

5053: p_count => p_msg_count,
5054: p_data => p_msg_data);
5055: end CREATE_ATTRIBUTE_VALUE;
5056:
5057: end AK_OBJECT_PVT;