APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on AHL_UTILITY_PVT

Line 803: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (

799: Ahl_Debug_Pub.debug( 'For create l_valid_flag -->' || l_valid_flag);
800: Ahl_Debug_Pub.debug( 'QUERY -->' || 'RESOURCE_SEQUENCE_NUM = ' || p_resrc_Require_rec.RESOURCE_SEQ_NUMBER ||
801: ' AND WORKORDER_OPERATION_ID = ' || p_resrc_Require_rec.WORKORDER_OPERATION_ID);
802:
803: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (
804: 'AHL_OPERATION_RESOURCES',
805: 'RESOURCE_SEQUENCE_NUM = ' || p_resrc_Require_rec.RESOURCE_SEQ_NUMBER ||
806: ' AND WORKORDER_OPERATION_ID = ' || p_resrc_Require_rec.WORKORDER_OPERATION_ID
807: );

Line 814: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (

810:
811: ' AND WORKORDER_OPERATION_ID = ' || p_resrc_Require_rec.WORKORDER_OPERATION_ID ||
812: ' AND OPERATION_RESOURCE_ID <> ' || p_resrc_Require_rec.OPERATION_RESOURCE_ID);
813:
814: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (
815: 'AHL_OPERATION_RESOURCES',
816: 'RESOURCE_SEQUENCE_NUM = ' || p_resrc_Require_rec.RESOURCE_SEQ_NUMBER ||
817: ' AND WORKORDER_OPERATION_ID = ' || p_resrc_Require_rec.WORKORDER_OPERATION_ID ||
818: ' AND OPERATION_RESOURCE_ID <> ' || p_resrc_Require_rec.OPERATION_RESOURCE_ID