APPS.AMS_DM_IMP_ATTRIBUTE_PVT dependencies on AMS_DM_IMP_ATTRIBUTES

Line 296: FROM AMS_DM_IMP_ATTRIBUTES

292: IS
293:
294: CURSOR c_get_imp_attribute(imp_attribute_id NUMBER) IS
295: SELECT *
296: FROM AMS_DM_IMP_ATTRIBUTES
297: WHERE imp_attribute_id = p_imp_attribute_rec.imp_attribute_id;
298:
299: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Imp_Attribute';
300: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;

Line 691: FROM ams_dm_imp_attributes

687: l_Dm_Imp_Attribute_id NUMBER;
688:
689: CURSOR c_imp_attribute IS
690: SELECT imp_attribute_id
691: FROM ams_dm_imp_attributes
692: WHERE imp_attribute_id = p_Dm_Imp_Attribute_id
693: AND object_version_number = p_object_version
694: FOR UPDATE NOWAIT;
695: BEGIN

Line 801: 'ams_dm_imp_attributes',

797: x_return_status := FND_API.g_ret_sts_success;
798:
799: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
800: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
801: 'ams_dm_imp_attributes',
802: 'model_id = ' || p_imp_attribute_rec.model_id ||
803: ' AND source_field_id = ' || p_imp_attribute_rec.source_field_id
804: );
805: IF l_valid_flag = FND_API.g_false THEN

Line 811: 'ams_dm_imp_attributes',

807: x_return_status := FND_API.g_ret_sts_error;
808: END IF;
809: ELSE
810: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
811: 'ams_dm_imp_attributes',
812: 'imp_attribute_id = ' || p_imp_attribute_rec.imp_attribute_id ||
813: ' AND imp_attribute_id <> ' || p_imp_attribute_rec.imp_attribute_id
814: );
815: IF l_valid_flag = FND_API.g_false THEN

Line 978: FROM ams_dm_imp_attributes

974: l_return_status VARCHAR2(1);
975:
976: CURSOR c_complete IS
977: SELECT *
978: FROM ams_dm_imp_attributes
979: WHERE imp_attribute_id = p_imp_attribute_rec.imp_attribute_id;
980: l_imp_attribute_rec c_complete%ROWTYPE;
981: BEGIN
982: x_complete_rec := p_imp_attribute_rec;

Line 1053: SELECT ams_dm_imp_attributes_s.NEXTVAL

1049: x_imp_attribute_rec OUT NOCOPY imp_attribute_rec_type
1050: )
1051: IS
1052: CURSOR c_id IS
1053: SELECT ams_dm_imp_attributes_s.NEXTVAL
1054: FROM dual;
1055:
1056: CURSOR c_id_exists (l_id IN NUMBER) IS
1057: SELECT 1

Line 1058: FROM AMS_DM_IMP_ATTRIBUTES

1054: FROM dual;
1055:
1056: CURSOR c_id_exists (l_id IN NUMBER) IS
1057: SELECT 1
1058: FROM AMS_DM_IMP_ATTRIBUTES
1059: WHERE imp_attribute_id = l_id;
1060:
1061: CURSOR c_lookup_field_id (l_model_id IN NUMBER, l_source_column_name IN VARCHAR2 ) IS
1062: SELECT f.list_source_field_id