eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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;