APPS.AMS_DMLIFT_PVT dependencies on AMS_DM_LIFT

Line 58: FROM AMS_DM_LIFT

54: l_LIFT_ID NUMBER;
55:
56: CURSOR c_Dmlift IS
57: SELECT LIFT_ID
58: FROM AMS_DM_LIFT
59: WHERE LIFT_ID = p_LIFT_ID
60: AND object_version_number = p_object_version
61: FOR UPDATE NOWAIT;
62:

Line 195: SELECT AMS_DM_LIFT_s.NEXTVAL

191: l_LIFT_ID NUMBER;
192: l_dummy NUMBER;
193:
194: CURSOR c_id IS
195: SELECT AMS_DM_LIFT_s.NEXTVAL
196: FROM dual;
197:
198: CURSOR c_id_exists (l_id IN NUMBER) IS
199: SELECT 1 FROM dual

Line 200: WHERE EXISTS (SELECT 1 FROM AMS_DM_LIFT

196: FROM dual;
197:
198: CURSOR c_id_exists (l_id IN NUMBER) IS
199: SELECT 1 FROM dual
200: WHERE EXISTS (SELECT 1 FROM AMS_DM_LIFT
201: WHERE LIFT_ID = l_id);
202:
203: BEGIN
204: -- Standard Start of API savepoint

Line 282: -- Invoke table handler(AMS_DM_LIFT_PKG.Insert_Row)

278:
279: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
280: END IF;
281:
282: -- Invoke table handler(AMS_DM_LIFT_PKG.Insert_Row)
283: AMS_DM_LIFT_PKG.Insert_Row(
284: px_lift_id => l_lift_id,
285: p_last_update_date => SYSDATE,
286: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 283: AMS_DM_LIFT_PKG.Insert_Row(

279: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
280: END IF;
281:
282: -- Invoke table handler(AMS_DM_LIFT_PKG.Insert_Row)
283: AMS_DM_LIFT_PKG.Insert_Row(
284: px_lift_id => l_lift_id,
285: p_last_update_date => SYSDATE,
286: p_last_updated_by => FND_GLOBAL.USER_ID,
287: p_creation_date => SYSDATE,

Line 393: FROM AMS_DM_LIFT

389: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
390:
391: CURSOR c_get_dmlift(p_lift_id NUMBER) IS
392: SELECT *
393: FROM AMS_DM_LIFT
394: WHERE lift_id = p_lift_id;
395:
396: -- Local Variables
397: l_object_version_number NUMBER;

Line 498: -- Invoke table handler(AMS_DM_LIFT_PKG.Update_Row)

494:
495: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
496: END IF;
497:
498: -- Invoke table handler(AMS_DM_LIFT_PKG.Update_Row)
499: BEGIN
500: AMS_DM_LIFT_PKG.Update_Row(
501: p_lift_id => p_Lift_rec.lift_id,
502: p_last_update_date => SYSDATE,

Line 500: AMS_DM_LIFT_PKG.Update_Row(

496: END IF;
497:
498: -- Invoke table handler(AMS_DM_LIFT_PKG.Update_Row)
499: BEGIN
500: AMS_DM_LIFT_PKG.Update_Row(
501: p_lift_id => p_Lift_rec.lift_id,
502: p_last_update_date => SYSDATE,
503: p_last_updated_by => FND_GLOBAL.USER_ID,
504: p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID,

Line 646: -- Invoke table handler(AMS_DM_LIFT_PKG.Delete_Row)

642:
643: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
644: END IF;
645:
646: -- Invoke table handler(AMS_DM_LIFT_PKG.Delete_Row)
647: BEGIN
648: AMS_DM_LIFT_PKG.Delete_Row(
649: p_LIFT_ID => p_LIFT_ID);
650: EXCEPTION

Line 648: AMS_DM_LIFT_PKG.Delete_Row(

644: END IF;
645:
646: -- Invoke table handler(AMS_DM_LIFT_PKG.Delete_Row)
647: BEGIN
648: AMS_DM_LIFT_PKG.Delete_Row(
649: p_LIFT_ID => p_LIFT_ID);
650: EXCEPTION
651: WHEN NO_DATA_FOUND THEN
652: AMS_Utility_PVT.error_message ('AMS_API_NO_DELETE');

Line 733: 'AMS_DM_LIFT',

729: BEGIN
730: x_return_status := FND_API.g_ret_sts_success;
731: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
732: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
733: 'AMS_DM_LIFT',
734: 'LIFT_ID = ''' || p_Lift_rec.LIFT_ID ||''''
735: );
736: ELSE
737: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 738: 'AMS_DM_LIFT',

734: 'LIFT_ID = ''' || p_Lift_rec.LIFT_ID ||''''
735: );
736: ELSE
737: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
738: 'AMS_DM_LIFT',
739: 'LIFT_ID = ''' || p_Lift_rec.LIFT_ID ||
740: ''' AND LIFT_ID <> ' || p_Lift_rec.LIFT_ID
741: );
742: END IF;

Line 864: AMS_Utility_PVT.error_message ('AMS_DM_LIFT_BAD_MODEL_ID');

860: 'AMS_DM_MODELS_ALL_B',
861: 'MODEL_ID',
862: p_lift_rec.model_id
863: ) = FND_API.g_false THEN
864: AMS_Utility_PVT.error_message ('AMS_DM_LIFT_BAD_MODEL_ID');
865: x_return_status := FND_API.g_ret_sts_error;
866: END IF;
867: END IF;
868: