APPS.AHL_VWP_VISITS_PVT dependencies on AHL_UTILITY_PVT

Line 4628: IF Ahl_Utility_Pvt.check_uniqueness(

4624:
4625: IF p_validation_mode = Jtf_Plsql_Api.g_create AND p_Visit_rec.VISIT_ID IS NOT NULL
4626: THEN
4627:
4628: IF Ahl_Utility_Pvt.check_uniqueness(
4629: 'Ahl_Visits_VL',
4630: 'VISIT_ID = ' || p_Visit_rec.VISIT_ID
4631: ) = Fnd_Api.g_false THEN
4632:

Line 4647: l_valid_flag := Ahl_Utility_Pvt.Check_Uniqueness (

4643:
4644: -- check if VISIT NUMBER is UNIQUE
4645: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
4646: IF (p_Visit_rec.VISIT_NUMBER IS NOT NULL) THEN
4647: l_valid_flag := Ahl_Utility_Pvt.Check_Uniqueness (
4648: 'Ahl_Visits_VL',
4649: 'VISIT_NUMBER = ''' || p_Visit_rec.VISIT_NUMBER || ''''
4650: );
4651: END IF;

Line 4654: l_valid_flag := Ahl_Utility_Pvt.Check_Uniqueness (

4650: );
4651: END IF;
4652: ELSE
4653: IF (p_Visit_rec.VISIT_NUMBER IS NOT NULL) THEN
4654: l_valid_flag := Ahl_Utility_Pvt.Check_Uniqueness (
4655: 'Ahl_Visits_VL',
4656: 'VISIT_NUMBER = ''' || p_Visit_rec.VISIT_NUMBER ||
4657: ''' AND VISIT_ID <> ' || p_Visit_rec.VISIT_ID
4658: );