APPS.AHL_VWP_VISITS_PVT dependencies on AHL_UTILITY_PVT

Line 6205: IF Ahl_Utility_Pvt.check_uniqueness(

6201:
6202: IF p_validation_mode = Jtf_Plsql_Api.g_create AND p_Visit_rec.VISIT_ID IS NOT NULL
6203: THEN
6204:
6205: IF Ahl_Utility_Pvt.check_uniqueness(
6206: 'Ahl_Visits_VL',
6207: 'VISIT_ID = ' || p_Visit_rec.VISIT_ID
6208: ) = Fnd_Api.g_false THEN
6209:

Line 6224: l_valid_flag := Ahl_Utility_Pvt.Check_Uniqueness (

6220:
6221: -- check if VISIT NUMBER is UNIQUE
6222: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
6223: IF (p_Visit_rec.VISIT_NUMBER IS NOT NULL) THEN
6224: l_valid_flag := Ahl_Utility_Pvt.Check_Uniqueness (
6225: 'Ahl_Visits_VL',
6226: 'VISIT_NUMBER = ''' || p_Visit_rec.VISIT_NUMBER || ''''
6227: );
6228: END IF;

Line 6231: l_valid_flag := Ahl_Utility_Pvt.Check_Uniqueness (

6227: );
6228: END IF;
6229: ELSE
6230: IF (p_Visit_rec.VISIT_NUMBER IS NOT NULL) THEN
6231: l_valid_flag := Ahl_Utility_Pvt.Check_Uniqueness (
6232: 'Ahl_Visits_VL',
6233: 'VISIT_NUMBER = ''' || p_Visit_rec.VISIT_NUMBER ||
6234: ''' AND VISIT_ID <> ' || p_Visit_rec.VISIT_ID
6235: );