APPS.AK_ATTRIBUTE_PVT dependencies on AK_ATTRIBUTE_PVT

Line 1: package body AK_Attribute_pvt as

1: package body AK_Attribute_pvt as
2: /* $Header: akdvatrb.pls 120.5 2006/11/30 23:21:34 tshort ship $ */
3:
4: --=======================================================
5: -- Function VALIDATE_ATTRIBUTE

Line 542: if AK_ATTRIBUTE_PVT.ATTRIBUTE_EXISTS (

538: /* now if we hit that error the exception handling calls update_attribute */
539: /* --
540: -- check to see if row already exists
541: --
542: if AK_ATTRIBUTE_PVT.ATTRIBUTE_EXISTS (
543: p_api_version_number => 1.0,
544: p_return_status => l_return_status,
545: p_attribute_application_id => p_attribute_application_id,
546: p_attribute_code => p_attribute_code) then

Line 923: if NOT AK_ATTRIBUTE_PVT.ATTRIBUTE_EXISTS (

919:
920: --
921: -- row should exists before inserting rows for other languages
922: --
923: if NOT AK_ATTRIBUTE_PVT.ATTRIBUTE_EXISTS (
924: p_api_version_number => 1.0,
925: p_return_status => l_return_status,
926: p_attribute_application_id => p_attribute_application_id,
927: p_attribute_code => p_attribute_code) then

Line 1021: AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE (

1017: p_data => p_msg_data);
1018: WHEN OTHERS THEN
1019: if (SQLCODE = -1) then
1020: rollback to start_create_attribute;
1021: AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE (
1022: p_validation_level => p_validation_level,
1023: p_api_version_number => 1.0,
1024: p_msg_count => p_msg_count,
1025: p_msg_data => p_msg_data,

Line 1168: if NOT AK_ATTRIBUTE_PVT.ATTRIBUTE_EXISTS (

1164:
1165: --
1166: -- error if attribute to be deleted does not exists
1167: --
1168: if NOT AK_ATTRIBUTE_PVT.ATTRIBUTE_EXISTS (
1169: p_api_version_number => 1.0,
1170: p_return_status => l_return_status,
1171: p_attribute_application_id => p_attribute_application_id,
1172: p_attribute_code => p_attribute_code) then

Line 2600: if AK_ATTRIBUTE_PVT.ATTRIBUTE_EXISTS (

2596: raise FND_API.G_EXC_ERROR;
2597: end if;
2598: elsif (l_state = 19) then
2599: if (l_token = 'ATTRIBUTE') then
2600: if AK_ATTRIBUTE_PVT.ATTRIBUTE_EXISTS (
2601: p_api_version_number => 1.0,
2602: p_return_status => l_return_status,
2603: p_attribute_application_id=>
2604: l_attribute_rec.attribute_application_id,

Line 2643: AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE (

2639: p_db_last_update_date => l_update2,
2640: p_last_update_login => l_attribute_rec.last_update_login,
2641: p_create_or_update => 'UPDATE')) then
2642:
2643: AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE (
2644: p_validation_level => p_validation_level,
2645: p_api_version_number => 1.0,
2646: p_msg_count => l_msg_count,
2647: p_msg_data => l_msg_data,

Line 2712: AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE (

2708: --
2709: -- Update record only if Update mode is set to true
2710: --
2711: elsif (AK_UPLOAD_GRP.G_UPDATE_MODE) then
2712: AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE (
2713: p_validation_level => p_validation_level,
2714: p_api_version_number => 1.0,
2715: p_msg_count => l_msg_count,
2716: p_msg_data => l_msg_data,

Line 2776: AK_ATTRIBUTE_PVT.CREATE_ATTRIBUTE (

2772: p_copy_redo_flag => l_copy_redo_flag
2773: );
2774: end if; -- /* if G_UPDATE_MODE G_NC_UPDATE_MODE*/
2775: else
2776: AK_ATTRIBUTE_PVT.CREATE_ATTRIBUTE (
2777: p_validation_level => p_validation_level,
2778: p_api_version_number => 1.0,
2779: p_msg_count => l_msg_count,
2780: p_msg_data => l_msg_data,

Line 3683: if AK_ATTRIBUTE_PVT.ATTRIBUTE_EXISTS (

3679: begin
3680: if (G_ATTRIBUTE_REDO_TBL.count > 0) then
3681: for l_rec_index in G_ATTRIBUTE_REDO_TBL.FIRST .. G_ATTRIBUTE_REDO_TBL.LAST loop
3682: if (G_ATTRIBUTE_REDO_TBL.exists(l_rec_index)) then
3683: if AK_ATTRIBUTE_PVT.ATTRIBUTE_EXISTS (
3684: p_api_version_number => 1.0,
3685: p_return_status => l_return_status,
3686: p_attribute_application_id=>
3687: G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute_application_id,

Line 3689: AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE (

3685: p_return_status => l_return_status,
3686: p_attribute_application_id=>
3687: G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute_application_id,
3688: p_attribute_code => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute_code) then
3689: AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE (
3690: p_validation_level => p_validation_level,
3691: p_api_version_number => 1.0,
3692: p_msg_count => l_msg_count,
3693: p_msg_data => l_msg_data,

Line 3752: AK_ATTRIBUTE_PVT.CREATE_ATTRIBUTE (

3748: p_pass => p_pass,
3749: p_copy_redo_flag => l_copy_redo_flag
3750: );
3751: else
3752: AK_ATTRIBUTE_PVT.CREATE_ATTRIBUTE (
3753: p_validation_level => p_validation_level,
3754: p_api_version_number => 1.0,
3755: p_msg_count => l_msg_count,
3756: p_msg_data => l_msg_data,

Line 3842: end AK_Attribute_pvt;

3838: p_data => l_msg_data);
3839:
3840: end UPLOAD_ATTRIBUTE_SECOND;
3841:
3842: end AK_Attribute_pvt;