APPS.AMS_DM_BINVALUES_PVT dependencies on AMS_DM_BIN_VALUES

Line 60: SELECT AMS_DM_BIN_VALUES_s.NEXTVAL

56: l_dummy NUMBER;
57: l_dm_binvalues_rec AMS_Dm_Binvalues_PVT.dm_binvalues_rec_type:= p_dm_binvalues_rec;
58:
59: CURSOR c_id IS
60: SELECT AMS_DM_BIN_VALUES_s.NEXTVAL
61: FROM dual;
62:
63: CURSOR c_id_exists (l_id IN NUMBER) IS
64: SELECT 1

Line 65: FROM AMS_DM_BIN_VALUES

61: FROM dual;
62:
63: CURSOR c_id_exists (l_id IN NUMBER) IS
64: SELECT 1
65: FROM AMS_DM_BIN_VALUES
66: WHERE BIN_VALUE_ID = l_id;
67:
68: BEGIN
69: -- Standard Start of API savepoint

Line 162: -- Invoke table handler(AMS_DM_BIN_VALUES_PKG.Insert_Row)

158:
159: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
160: END IF;
161:
162: -- Invoke table handler(AMS_DM_BIN_VALUES_PKG.Insert_Row)
163: AMS_DM_BIN_VALUES_PKG.Insert_Row(
164: px_bin_value_id => l_dm_binvalues_rec.bin_value_id,
165: p_last_update_date => SYSDATE,
166: p_last_updated_by => G_USER_ID,

Line 163: AMS_DM_BIN_VALUES_PKG.Insert_Row(

159: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
160: END IF;
161:
162: -- Invoke table handler(AMS_DM_BIN_VALUES_PKG.Insert_Row)
163: AMS_DM_BIN_VALUES_PKG.Insert_Row(
164: px_bin_value_id => l_dm_binvalues_rec.bin_value_id,
165: p_last_update_date => SYSDATE,
166: p_last_updated_by => G_USER_ID,
167: p_creation_date => SYSDATE,

Line 266: FROM AMS_DM_BIN_VALUES

262:
263:
264: CURSOR c_get_dm_binvalues(bin_value_id NUMBER) IS
265: SELECT *
266: FROM AMS_DM_BIN_VALUES
267: WHERE bin_value_id = bin_value_id;
268:
269:
270: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Dm_Binvalues';

Line 439: -- Invoke table handler(AMS_DM_BIN_VALUES_PKG.Update_Row)

435:
436: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
437: END IF;
438:
439: -- Invoke table handler(AMS_DM_BIN_VALUES_PKG.Update_Row)
440: AMS_DM_BIN_VALUES_PKG.Update_Row(
441: p_bin_value_id => l_tar_dm_binvalues_rec.bin_value_id,
442: p_last_update_date => SYSDATE,
443: p_last_updated_by => G_USER_ID,

Line 440: AMS_DM_BIN_VALUES_PKG.Update_Row(

436: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
437: END IF;
438:
439: -- Invoke table handler(AMS_DM_BIN_VALUES_PKG.Update_Row)
440: AMS_DM_BIN_VALUES_PKG.Update_Row(
441: p_bin_value_id => l_tar_dm_binvalues_rec.bin_value_id,
442: p_last_update_date => SYSDATE,
443: p_last_updated_by => G_USER_ID,
444: p_creation_date => SYSDATE,

Line 540: DELETE FROM AMS_DM_BIN_VALUES

536:
537: --
538: -- Api body
539: --
540: DELETE FROM AMS_DM_BIN_VALUES
541: WHERE source_field_id = p_datasource_field_id;
542:
543: --
544: -- End of API body

Line 625: -- Invoke table handler(AMS_DM_BIN_VALUES_PKG.Delete_Row)

621:
622: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
623: END IF;
624:
625: -- Invoke table handler(AMS_DM_BIN_VALUES_PKG.Delete_Row)
626: AMS_DM_BIN_VALUES_PKG.Delete_Row(
627: p_BIN_VALUE_ID => p_BIN_VALUE_ID);
628: --
629: -- End of API body

Line 626: AMS_DM_BIN_VALUES_PKG.Delete_Row(

622: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
623: END IF;
624:
625: -- Invoke table handler(AMS_DM_BIN_VALUES_PKG.Delete_Row)
626: AMS_DM_BIN_VALUES_PKG.Delete_Row(
627: p_BIN_VALUE_ID => p_BIN_VALUE_ID);
628: --
629: -- End of API body
630: --

Line 714: FROM AMS_DM_BIN_VALUES

710: l_BIN_VALUE_ID NUMBER;
711:
712: CURSOR c_Dm_Binvalues IS
713: SELECT BIN_VALUE_ID
714: FROM AMS_DM_BIN_VALUES
715: WHERE BIN_VALUE_ID = p_BIN_VALUE_ID
716: AND object_version_number = p_object_version
717: FOR UPDATE NOWAIT;
718:

Line 836: 'AMS_DM_BIN_VALUES',

832:
833: x_return_status := FND_API.g_ret_sts_success;
834: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
835: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
836: 'AMS_DM_BIN_VALUES',
837: 'BIN_VALUE_ID = ''' || p_dm_binvalues_rec.BIN_VALUE_ID ||''''
838: );
839: ELSE
840: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 841: 'AMS_DM_BIN_VALUES',

837: 'BIN_VALUE_ID = ''' || p_dm_binvalues_rec.BIN_VALUE_ID ||''''
838: );
839: ELSE
840: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
841: 'AMS_DM_BIN_VALUES',
842: 'BIN_VALUE_ID = ''' || p_dm_binvalues_rec.BIN_VALUE_ID ||
843: ''' AND BIN_VALUE_ID <> ' || p_dm_binvalues_rec.BIN_VALUE_ID
844: );
845: END IF;

Line 1016: FROM ams_dm_bin_values

1012: l_return_status VARCHAR2(1);
1013:
1014: CURSOR c_complete IS
1015: SELECT *
1016: FROM ams_dm_bin_values
1017: WHERE bin_value_id = p_dm_binvalues_rec.bin_value_id;
1018: l_dm_binvalues_rec c_complete%ROWTYPE;
1019: BEGIN
1020: