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.12020000.2 2012/11/20 18:59:45 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 925: if NOT AK_ATTRIBUTE_PVT.ATTRIBUTE_EXISTS (

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

Line 1025: AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE (

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

Line 1172: if NOT AK_ATTRIBUTE_PVT.ATTRIBUTE_EXISTS (

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

Line 2604: if AK_ATTRIBUTE_PVT.ATTRIBUTE_EXISTS (

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

Line 2647: AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE (

2643: p_db_last_update_date => l_update2,
2644: p_last_update_login => l_attribute_rec.last_update_login,
2645: p_create_or_update => 'UPDATE')) then
2646:
2647: AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE (
2648: p_validation_level => p_validation_level,
2649: p_api_version_number => 1.0,
2650: p_msg_count => l_msg_count,
2651: p_msg_data => l_msg_data,

Line 2716: AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE (

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

Line 2780: AK_ATTRIBUTE_PVT.CREATE_ATTRIBUTE (

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

Line 3693: if AK_ATTRIBUTE_PVT.ATTRIBUTE_EXISTS (

3689: begin
3690: if (G_ATTRIBUTE_REDO_TBL.count > 0) then
3691: for l_rec_index in G_ATTRIBUTE_REDO_TBL.FIRST .. G_ATTRIBUTE_REDO_TBL.LAST loop
3692: if (G_ATTRIBUTE_REDO_TBL.exists(l_rec_index)) then
3693: if AK_ATTRIBUTE_PVT.ATTRIBUTE_EXISTS (
3694: p_api_version_number => 1.0,
3695: p_return_status => l_return_status,
3696: p_attribute_application_id=>
3697: G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute_application_id,

Line 3699: AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE (

3695: p_return_status => l_return_status,
3696: p_attribute_application_id=>
3697: G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute_application_id,
3698: p_attribute_code => G_ATTRIBUTE_REDO_TBL(l_rec_index).attribute_code) then
3699: AK_ATTRIBUTE_PVT.UPDATE_ATTRIBUTE (
3700: p_validation_level => p_validation_level,
3701: p_api_version_number => 1.0,
3702: p_msg_count => l_msg_count,
3703: p_msg_data => l_msg_data,

Line 3762: AK_ATTRIBUTE_PVT.CREATE_ATTRIBUTE (

3758: p_pass => p_pass,
3759: p_copy_redo_flag => l_copy_redo_flag
3760: );
3761: else
3762: AK_ATTRIBUTE_PVT.CREATE_ATTRIBUTE (
3763: p_validation_level => p_validation_level,
3764: p_api_version_number => 1.0,
3765: p_msg_count => l_msg_count,
3766: p_msg_data => l_msg_data,

Line 3854: end AK_Attribute_pvt;

3850: p_data => l_msg_data);
3851: G_ATTRIBUTE_REDO_TBL.DELETE;
3852: end UPLOAD_ATTRIBUTE_SECOND;
3853:
3854: end AK_Attribute_pvt;