DBA Data[Home] [Help]

APPS.AMS_DM_TARGET_VALUE_PVT dependencies on AMS_DM_TARGET_VALUES_B

Line 68: SELECT AMS_DM_TARGET_VALUES_B_s.NEXTVAL

64: l_dm_target_value_rec AMS_Dm_Target_Value_PVT.dm_target_value_rec_type := p_dm_target_value_rec;
65: l_datasource_id NUMBER;
66:
67: CURSOR c_id IS
68: SELECT AMS_DM_TARGET_VALUES_B_s.NEXTVAL
69: FROM dual;
70:
71: CURSOR c_id_exists (l_id IN NUMBER) IS
72: SELECT 1

Line 171: -- Invoke table handler(AMS_DM_TARGET_VALUES_B_PKG.Insert_Row)

167:
168: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
169: END IF;
170:
171: -- Invoke table handler(AMS_DM_TARGET_VALUES_B_PKG.Insert_Row)
172: AMS_DM_TARGET_VALUES_B_PKG.Insert_Row(
173: px_target_value_id => l_dm_target_value_rec.TARGET_VALUE_ID,
174: p_last_update_date => SYSDATE,
175: p_last_updated_by => G_USER_ID,

Line 172: AMS_DM_TARGET_VALUES_B_PKG.Insert_Row(

168: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
169: END IF;
170:
171: -- Invoke table handler(AMS_DM_TARGET_VALUES_B_PKG.Insert_Row)
172: AMS_DM_TARGET_VALUES_B_PKG.Insert_Row(
173: px_target_value_id => l_dm_target_value_rec.TARGET_VALUE_ID,
174: p_last_update_date => SYSDATE,
175: p_last_updated_by => G_USER_ID,
176: p_creation_date => SYSDATE,

Line 428: -- Invoke table handler(AMS_DM_TARGET_VALUES_B_PKG.Update_Row)

424:
425: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
426: END IF;
427:
428: -- Invoke table handler(AMS_DM_TARGET_VALUES_B_PKG.Update_Row)
429: AMS_DM_TARGET_VALUES_B_PKG.Update_Row(
430: p_target_value_id => l_tar_dm_target_value_rec.target_value_id,
431: p_last_update_date => SYSDATE,
432: p_last_updated_by => G_USER_ID,

Line 429: AMS_DM_TARGET_VALUES_B_PKG.Update_Row(

425: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
426: END IF;
427:
428: -- Invoke table handler(AMS_DM_TARGET_VALUES_B_PKG.Update_Row)
429: AMS_DM_TARGET_VALUES_B_PKG.Update_Row(
430: p_target_value_id => l_tar_dm_target_value_rec.target_value_id,
431: p_last_update_date => SYSDATE,
432: p_last_updated_by => G_USER_ID,
433: p_last_update_login => G_LOGIN_ID,

Line 524: WHERE TARGET_VALUE_ID in (SELECT TARGET_VALUE_ID FROM AMS_DM_TARGET_VALUES_B WHERE TARGET_ID = p_TARGET_ID);

520: --
521: -- Api body
522: --
523: DELETE FROM ams_dm_target_values_tl
524: WHERE TARGET_VALUE_ID in (SELECT TARGET_VALUE_ID FROM AMS_DM_TARGET_VALUES_B WHERE TARGET_ID = p_TARGET_ID);
525:
526: DELETE FROM AMS_DM_TARGET_VALUES_B
527: WHERE TARGET_ID = p_TARGET_ID;
528:

Line 526: DELETE FROM AMS_DM_TARGET_VALUES_B

522: --
523: DELETE FROM ams_dm_target_values_tl
524: WHERE TARGET_VALUE_ID in (SELECT TARGET_VALUE_ID FROM AMS_DM_TARGET_VALUES_B WHERE TARGET_ID = p_TARGET_ID);
525:
526: DELETE FROM AMS_DM_TARGET_VALUES_B
527: WHERE TARGET_ID = p_TARGET_ID;
528:
529: --
530: -- End of API body

Line 655: -- Invoke table handler(AMS_DM_TARGET_VALUES_B_PKG.Delete_Row)

651: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Before Delete: TARGET_ID = ' || l_target_id );
652:
653: END IF;
654:
655: -- Invoke table handler(AMS_DM_TARGET_VALUES_B_PKG.Delete_Row)
656: AMS_DM_TARGET_VALUES_B_PKG.Delete_Row(
657: p_TARGET_VALUE_ID => p_TARGET_VALUE_ID);
658:
659:

Line 656: AMS_DM_TARGET_VALUES_B_PKG.Delete_Row(

652:
653: END IF;
654:
655: -- Invoke table handler(AMS_DM_TARGET_VALUES_B_PKG.Delete_Row)
656: AMS_DM_TARGET_VALUES_B_PKG.Delete_Row(
657: p_TARGET_VALUE_ID => p_TARGET_VALUE_ID);
658:
659:
660: -- After successfully deleteing the target value, check if there are no more

Line 781: FROM AMS_DM_TARGET_VALUES_B

777: l_TARGET_VALUE_ID NUMBER;
778:
779: CURSOR c_Dm_Target_Value IS
780: SELECT TARGET_VALUE_ID
781: FROM AMS_DM_TARGET_VALUES_B
782: WHERE TARGET_VALUE_ID = p_TARGET_VALUE_ID
783: AND object_version_number = p_object_version
784: FOR UPDATE NOWAIT;
785:

Line 898: FROM ams_dm_target_values_b tvb

894: l_valid_flag VARCHAR2(1);
895:
896: CURSOR c_op_value IS
897: SELECT FND_API.g_false
898: FROM ams_dm_target_values_b tvb
899: WHERE tvb.target_id = p_dm_target_value_rec.target_id
900: AND tvb.target_operator = p_dm_target_value_rec.target_operator
901: AND tvb.target_value = p_dm_target_value_rec.target_value
902: ;

Line 908: FROM ams_dm_target_values_b tvb

904: -- March 17, 2003 - nyostos
905: -- Added following query for UPDATE mode
906: CURSOR c_op_value_updt IS
907: SELECT FND_API.g_false
908: FROM ams_dm_target_values_b tvb
909: WHERE tvb.target_id = p_dm_target_value_rec.target_id
910: AND tvb.target_operator = p_dm_target_value_rec.target_operator
911: AND tvb.target_value = p_dm_target_value_rec.target_value
912: AND tvb.target_value_id <> p_dm_target_value_rec.target_value_id

Line 921: 'AMS_DM_TARGET_VALUES_B',

917:
918: -- validate uniqueness of primary key
919: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
920: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
921: 'AMS_DM_TARGET_VALUES_B',
922: 'TARGET_VALUE_ID = ''' || p_dm_target_value_rec.TARGET_VALUE_ID ||''''
923: );
924: ELSE
925: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 926: 'AMS_DM_TARGET_VALUES_B',

922: 'TARGET_VALUE_ID = ''' || p_dm_target_value_rec.TARGET_VALUE_ID ||''''
923: );
924: ELSE
925: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
926: 'AMS_DM_TARGET_VALUES_B',
927: 'TARGET_VALUE_ID = ''' || p_dm_target_value_rec.TARGET_VALUE_ID ||
928: ''' AND TARGET_VALUE_ID <> ' || p_dm_target_value_rec.TARGET_VALUE_ID
929: );
930: END IF;